CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9307.TXT

Text File | 1993-12-29 | 363KB | 8,455 lines

=========================================================================
Date:         Thu, 1 Jul 1993 00:50:00 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         thomas albert outlerchioi <[e-mail]>

FROM:
The Communication Circle
918 La Senda Lane, NW
Albuquerque, NM 87107
Call: [phone]
Fax: [phone]


FOR RELEASE JUNE 22, 1993


THE WORST MANUAL OF THE YEAR:
A COMPETITION FROM HELL

        If you've ever felt let down by a VCR manual, frustrated by
your computer's documentation, or downright crazed by the instructions
for some toy, here's your chance to fight back.  You can nominate that
lousy manual to be acclaimed as RThe Worst Manual of the Year.
        Sponsored by the Communication Circle, a group of experienced
and fed-up professional writers, the competition for the worst manual
of the year aims to shame manufacturers into providing manuals we can
actually use.  The best consumer companies have improved a lot, over
the last few years, says Jonathan Price, President of the Communication
Circle.  But there are still too many bad manuals out there.  You
usually can't find what you need, and if you do find it, you can't
understand what they're saying, or the diagram's such a mess you give up.
        Price urges you to send in those abominable manuals.  Look
through your pile of manuals and send us the one that helps you the
least, frustrates you the most, and generally makes your life miserable.
Write a short note saying why youUre nominating this book as your candidate
for the Worst Manual of the Year.  We don't care what year it was printed;
if you used it this year, and you hate it, tell us why.
        If your candidate wins (or places), you get a custom T-shirt
showing the cover of the manual selected as Worst Manual of the Year,
with the slogan, I fingered the Worst Manual of the Year, 1993.  As a
bonus, you get a copy of Jonathan Price's Put That In Writing (Viking
Press), and a certificate of honor in the war against useless manuals.
        The Communication Circle will announce the Worst Manual of the
Year to the press on December 7, 1993; distribute copies of your letters
(anonymously if you wish); and award the offending company a garish
Certificate of Bad Taste.  To correct their errors, the company will also
receive a copy of How to Communicate Technical Information by Jonathan
Price and Henry Korman (Benjamin/ Cummings, 1993). So scan those shelves.
Which manual has caused you the most grief this year?

Mail the book with your complaints to:

The Worst Manual of the Year
c/o The Communication Circle
918 La Senda, N.W.
Albuquerque, NM 87107.

Absolute last-chance deadline for submitting monster manuals: Halloween, 1993.

This press release has been distributed widely across the internet. But if
you know another list or a personal net-friend who might want to read it,
please forward it on.

If you have any questions about the contest, please write T. Outler at
[e-mail]. Please don't send descriptions of manuals via e-mail,
though. We need to get those, along with a copy of the horror text, in
the mail.

Thanks for reading, and go get those miserable manuals!


 ###
=========================================================================
Date:         Thu, 1 Jul 1993 16:00:09 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Report

Brian,

Thanks. However, I don't get what U mean "Change the Running Sum property to the
    value that is appropriate for your needs ( over group or over all )".

There is another method of creating a running line number for every record.
I create a query of what I want and output my query into a table. I then add ano
   ther field of type counter to this newly-created table.

Chor Ling
=========================================================================
Date:         Thu, 1 Jul 1993 16:21:50 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Malcolm Smith <[e-mail]>
Subject:      Please Register me

Hi,
 I'd like to receive mail from this discussion group.

I apologise in advance if sending this direct to the discussion group
rather than a registration address has irrated the "minder" of the list
but I can't find the address for registration... only the address for
discussion...

Thanks in advance registering me

-malc-
=========================================================================
Date:         Thu, 1 Jul 1993 12:04:50 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John J. Posner" <[e-mail]>
Subject:      Re: your mail
In-Reply-To:  <[e-mail]>; from "thomas albert
              outlerchioi" at Jul 1, 93 12:50 am

*** thomas albert outlerchioi said:
<>
<>         If you've ever felt let down by a VCR manual, frustrated by
<> your computer's documentation, or downright crazed by the instructions
<> for some toy, here's your chance to fight back.  You can nominate that
<> lousy manual to be acclaimed as RThe Worst Manual of the Year.

A halfhearted dissent ...

I've been a tech writer since 1977. One of the reasons I switched from
editing math textbooks to writing computer manuals was my discovery
that computer manuals *were* often lousy. ("Hey, I can do better than
that!")

So I've written lots of books in the last decade and a half.  Some of
them turned out fine, some not so fine. Writing a good technical
manual is not that easy. And all the reader of the manual sees is the
end product, not the extenuating circumstances: the roadblocks,
false starts, lack of resources, impossible schedules, nonperforming
reviewers, etc.

When I joined in my college band, then all-male, there was still an
occasional "ugliest date" competition. I was ashamed and appalled by
the casual cruelty, and I was very happy when things eventually
changed. So this is different?

I wouldn't want to impose political correctness on anyone, or even
spoil some "innocent good fun." But I suspect that all the
person-hours spent on this competition could be put to better use
researching and writing better manuals.

Curmudgeonly yours ...

--
   John Posner, Atria Software, Inc.
   24 Prime Park Way  Natick, MA  01760
   [phone] x26
   [e-mail]
   uunet!viewpnt!jjp
=========================================================================
Date:         Fri, 2 Jul 1993 12:21:43 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "M. Ederveen" <[e-mail]>
Subject:      OLE problem

Hiya all!


When fine-tuning the application I made with Access the following
problem occurred:

I'm using a picture (OLE-object) of a persons' autograph in the database.
The picture is supposed to be scanned and Pasted into the form.
I created a custom menu bar with the Paste function added.
This works fine.
Only thing is: I'd like to protect the picture from being overwritten by
mistake. So I tried using the ISNULL function in the same macro that
activates the Paste function in the custom menu bar. This works but not
good: the check is made properly but then the Paste function cannot be
activated anymore. Also the field property of an OLE-object doesn't have
features like ON-ENTER and ON-UPDATE, so how can I do this?

Greetings,


Martin.



-------------------------------------------------------------------------------
|  ing. Martin W. Ederveen           |  "In the future there will be real     |
|  Hogeschool Eindhoven              |   thinking machines.                   |
|  Rachelsmolen 1                    |   Yes, but who's thoughts will they    |
|  5612 MA Eindhoven                 |   be thinking?"                        |
|  tel. [phone]             |                                        |
|  [e-mail]              |   Quotation from Dr.Who: The Curse     |
|  [e-mail]                    |   of Fenric                            |
-------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 2 Jul 1993 07:29:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Scott,
              WW Mfg IM&T @Storage Mat'ls MLO1-5/B94 02-Jul-1993 0732"
              <"memit::blessley_s"@MEMIT.ENET.DEC.COM>
Subject:      Unsubscribe

Please.
=========================================================================
Date:         Fri, 2 Jul 1993 08:53:34 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Unsubscribe
In-Reply-To:  Message of Fri,
              2 Jul 1993 07:29:00 EDT from <memit::blessley_s@ME
              MIT.ENET.DEC.COM>

Folks, I'm sorry to have to reply to the list on this one.

"memit::blessing_s"@MEMIT.ENET.DEC.COM does not appear in the ACCESS-L
list.  Would whomever is responsible for this user please delete him?
Thank you.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 2 Jul 1993 10:43:48 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Security white paper take 2 :)

The security white paper has been uploaded to CICA, where it is in the
/pub/pc/win3/uploads directory.  (It's under the name ACC-SEC.TXT)

Note that ACC-KB.EXE, along with all other June uploads to CICA, is now
in the /pub/pc/win3/uploads/JUN93 directory.

CICA (the Center for Innovative Computer Applications) is at

FTP.CICA.INDIANA.EDU

or for those of you who need the IP address, 129.79.20.17 .

CICA supports only 30 concurrent anonymous FTP sessions and it is a busy
site, so don't be discouraged if you can't sign on immediately.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 2 Jul 1993 12:26:03 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Greer <[e-mail]>
Subject:      unsubscribe

Please unsubscribe me.
=========================================================================
Date:         Fri, 2 Jul 1993 14:15:28 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Merging two tables in a query

Okay, here's one for the gurus.  Consider a database with the following
two tables.

Cities                                  Ages
==================================      ===============================
Name            City                    Name            Age
-------------   ------------------      --------------  ---------------
George          Seattle                 George          30
John            Chicago                 Mary            42
Mary            Miami                   Steve           26

The Name field is the primary key for each table.
The challenge is to create a query which produces the following
datasheet view:

Name            City            Age
------------    --------------  ---------
George          Seattle         30
John            Chicago
Mary            Miami           42
Steve                           26

Certain constraints apply:
1.  There are no other pre-existing tables in the database that might
    be used to link the two.
2.  These tables are attached or imported periodically from another source,
    so maintaining a single unified table in Access is not an option.
3.  I recognize there may be ways to produce this view as a table,
    but would prefer to work with the data in a query.

I would term this a "merge" or "union" operation.  It's a generic
data manipulation that I have bumped up against repeatedly in managing
data in spreadsheets, and cannot figure how to do it now in Access.

A left outer join leaves out Steve; a right outer join leaves out John.
An equi-join leaves out both.  There seems to be a fourth option that
Access is missing.  In PC Mag's "Database Wars" review of Access, they
mentioned that Access does not support the SQL Union command.  I don't
know SQL; is this Union command related to what I am proposing above?

Any help would be appreciated, preferably in producing a query, but
also in producing a table as a last resort.  Thanks.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Fri, 2 Jul 1993 16:41:04 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Merging two tables in a query
In-Reply-To:  Message of Fri,
              2 Jul 1993 14:15:28 PDT from <[e-mail]. EDU>

Robert, I've run into this problem too.  I think I ended up giving up. :)
But I am willing to try again...obviously this is not something a select
query is going to pull out for you, since the select query works on the
assumption that you want records with data in every field.  (If this isn't
clear, blame it on the end of the day and a 3-day weekend ahead.  :)
I'll see what I can work up and if no one else gets to the list any time
soon, I'll share my results with you.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 2 Jul 1993 17:47:58 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Eduardo Rodriguez <[e-mail]>
Subject:      VLDB\'94 Conference Announcement and Preliminary Call for Papers

                                  VLDB'94

          Conference Announcement and Preliminary Call for Papers

           20th International Conference on Very Large Data Bases

                              Santiago - Chile

                           September 12-15, 1994




Scope
=====

A distinguished history of  20 years has established  VLDB at the center  of
the international data base community.  It is one of the oldest  established
forums of discussion in  the international database  community and,  without
doubt, one of the most eminent.
  VLDB'94 is to  take place in Santiago, Chile, a hospitable modern  capital
city landmarked by the Mapocho river and the impressive heights of the Andes
mountains.
  We invite  you to submit papers  reporting recent research results in  the
general field of  databases.   In  addition,  to mark  the 20th  anniversary
of VLDB special efforts  are being made  to further the  goal of leading  in
reporting and stimulating  new research  directions.   To  this purpose,  we
solicit papers and  panel proposals  on speculative  and futuristic  topics.
We also encourage papers on  novel and challenging applications of  database
technology in designing and building complex information systems.
  A  new aspect  of the  conference is  the industrial  cases program.    We
encourage submission of  papers describing work  of significant interest  to
industry, particularly  in areas  providing interesting  directions for  the
development of databases.  We seek to provide a forum to discuss experiences
in applying databases to real life situations.  In the evaluation of  papers
submitted to this program,  the committee  will consider novelty,  technical
quality and  the value  of  reported results  to developers  of  information
systems.
  A  high-quality  tutorial program  will be  offered  in both  English  and
Spanish.


Topics of Interest
==================

The topics of interest include but are not limited to:

   Extended Relational Databases         Database Languages
   Object Oriented Databases             Data Models and Database Design
   Knowledge Base Management Systems     Data Consistency, Integrity and
 Security
   Temporal and Spatial Databases        Optimization and Performance
   Multimedia Databases                  Concurrency and Transaction Management
   Heterogeneous Databases               Storage Management
   Engineering and Scientific Databases  Persistent Object Systems
   Parallel and Distributed Databases    Architectures
   Text Databases                        Implementation Issues
   Graphical Query Languages             User Interfaces





Paper Submission
================

Six copies of original papers not exceeding 5000 words (double spaced pages,
including keywords) should be submitted by the 23th of February 1994, to the
appropriate regional program chair:


   North-american Program Chair:               European Program Chair:
   -----------------------------               -----------------------

   Carlo Zaniolo                               Matthias Jarke
   USA                                         Germany

   Computer Science Department                 RWTH-Aachen
   University of California, Los Angeles       Informatik V, Ahornstr.  55
   405 Hilgard Avenue, CA 90024                52074 Aachen, Germany
   e-mail:  [e-mail]                email:
 [e-mail]
   tel:  [phone]                     tel:  [phone]
   fax:  [phone]                     fax:  [phone]

   Latin-America, Pacific Basin
   and Far-East Program Chair:
   ---------------------------

   Jorge Bocca
   Chile

   (Latin-American region)                     (Other regions)
   Depto. de Ciencias de la Computacion        School of Computer Science
   Universidad de Chile                        University of Birmingham
   Blanco Encalada 2120                        Edgbaston
   Santiago                                    Birmingham B15 2TT
   Chile                                       United Kingdom
   e-mail:  [e-mail]               e-mail:  [e-mail]
   tel:  [phone]                      tel:  [phone]
   fax:  [phone]                      fax:  [phone]




Tutorials
=========

Tutorial proposals should be sent by air-mail, fax or e-mail to one of:

   Alberto Mendelzon                           Ricardo Baeza-Yates
   Canada                                      Chile

   CSRI                                        Depto. de Ciencias de la
 Computacion
   University of Toronto                       Universidad de Chile
   Toronto                                     Blanco encalada 2120
   Canada M5S 1A1                              Santiago, Chile
   e-mail:  [e-mail]              e-mail:  [e-mail]
   tel:  [phone]                     tel:  [phone]
   fax:  [phone]                     fax:  [phone]


  Some  suggested,  but not  exclusive,  tutorial  topics are:    multimedia
data management, scientific databases, geographic information systems,  user
interfaces and visualization,  object-oriented analysis  and design,  active
databases, transaction processing, distributed object management, persistent
object systems,  database programming  languages, standards  and  technology
integration, etc.





Industrials Cases
=================

The VDLB Conference  will set up  for the  first time a  section devoted  to
the discussion of experiences  of commercial use  of Databases in  industry,
including the discussion of new leading products.
  Authors are requested  to submit their papers within the dates and  format
established for the  rest of the  conference, except that  papers should  be
submitted to one of  the following members of  the Industrial Cases  program
committee:


Jose A. Blakeley                            Felipe Carino Jr.
USA                                         USA

Texas Instruments                           NCR/Teradata Corporation
13510 N. Central Expressway, MS 238         100 N. Sepulveda Blvd
Dallas, Texas 75243                         El Segundo, CA 90245
e-mail:  [e-mail]                email:
 [e-mail]
tel:  [phone]                     tel:  [phone]
fax:  [phone]                     fax:  [phone]


Guillermo Lois                              Ivan Tabkha (Chair)
Sweden                                      Chile

IBM Nordic Lab                              Depto. de Ciencias de la Computacion
BOX 962, 181 09 Lidingo, Sweden             Universidad de Chile
Lidingo, Sweden                             Blanco Encalada 2120
e-mail:  [e-mail]        e-mail:  [e-mail]
tel:  [phone]                      tel:  [phone]
fax:  [phone]                      fax:  [phone]



Panels
======

Proposals for panel sessions should be sent to:

   Ron Morrison                                Computer Science
   United Kingdom                              University of St.  Andrews
                                               St.  Andrews - Fife KY16 9SS
                                               United Kingdom
                                               e-mail:  [e-mail]
                                               tel:  [phone]
                                               fax:  [phone]




Important Dates
===============

Paper, Panel, Tutorial and
Industrial Cases Submissions:....................... 23 February, 1994
Notification of Acceptance:......................... 25 April, 1994
Conference:......................................... 12-15 September, 1994






Local Organization Committee
============================

General Chair:                              Organization Chair:
-------------                               -------------------

Jorge Olivos                                Patricio Poblete
Chile                                       Chile

Depto. de Ciencias de la Computacion        Depto. de Ciencias de la Computacion
Universidad de Chile                        Universidad de Chile
e-mail:  [e-mail]              e-mail:  [e-mail]

Organization Vice-Chair:
------------------------

Ivan Tabkha                                 Depto. de Ciencias de la Computacion
Chile                                       Universidad de Chile
                                            e-mail:  [e-mail]


Conference Officers
===================


Geographical Chairs:
-------------------

Europe                        North-America            Latin-America,
------                        -------------            Pacific Basin and
 Far-East

 --------------------------

Mike Freeston                 Mario Schkolnick         Jorge Vidart
ECRC                          IBM                      U. de la Republica
Germany                       USA                      Uruguay


Treasurer                     VLDB Foundation Representative  Publicity
--------                      ------------------------------  ---------

Nancy Hitschfeld              Erich Neuhold                   Keith Jeffery
Universidad de Chile          IPSI                            SERC/RAL
Chile                         Germany                         United Kingdom


Corporate Sponsors
==================

ORACLE, SISTECO, SYBASE, SYNAPSIS, UNISYS.


Supporters
==========

CHILEAN COMPUTER SCIENCE SOCIETY, CONICYT,  CORREOS de CHILE, UNIVERSITY  of
CHILE, UNIVERSITY of BIRMINGHAM, SERC(UK).


Social Program
==============

CONFIATUR                                         Francisco Noguera 201
                                                  Santiago, Chile
                                                  tel and fax:  [phone]




For further information, please contact any  member of the local organization
committee  by e-mail,  fax, or  mail. There is also a VLDB database server
accessible through  our local Internet Gopher service at gopher.dcc.uchile.cl.

The local organization full address is:


  VLDB'94 Conference
  Departamento de Ciencias de la Computacion
  Universidad de Chile
  Blanco Encalada 2120
  Santiago, Chile
  e-mail:  [e-mail]
  tel:  [phone]
  fax:  [phone]
=========================================================================
Date:         Fri, 2 Jul 1993 18:22:48 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Security white paper take 2.1

> CICA supports only 30 concurrent anonymous FTP sessions and it is a busy
> site, so don't be discouraged if you can't sign on immediately.


And because of this limitation, CICA is mirrrored at other sites...




Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
CARmel, Indiana (carMEL is in California)
=========================================================================
Date:         Fri, 2 Jul 1993 18:22:16 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Security white paper take 2.1
In-Reply-To:  Message of Fri,
              2 Jul 1993 18:22:48 EDT from <72410.2162@COMPUSERV E.COM>

On Fri, 2 Jul 1993 18:22:48 EDT Phillip (Phil) Paxton said:
>> CICA supports only 30 concurrent anonymous FTP sessions and it is a busy
>> site, so don't be discouraged if you can't sign on immediately.
>
>
>And because of this limitation, CICA is mirrrored at other sites...
>

Right.  And I don't have a list of them.  Do you?  And I suspect that the
new uploads <aren't> mirrored.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 3 Jul 1993 19:28:00 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         CALLAHAN <[e-mail]>
Subject:      Re: Merging two tables in a query

[e-mail] (Robert Grinnell) writes:

>I would term this a "merge" or "union" operation.  It's a generic
>data manipulation that I have bumped up against repeatedly in managing
>data in spreadsheets, and cannot figure how to do it now in Access.

Well, there is a file on CompuServe in MSACCESS Forum Library 3 named
UNION.ZIP. It purports to do what you are asking, or something similar,
I think. It violates one of your constraints (no existing tables to do
links) but it is a constant table so maybe you can live with it. Anyway,
I'd upload but I don't have an ftp connection. I can UUENCODE it and
send it to the list, but it's pretty big after the encoding. Maybe I
can send it to Nathan and he can make it available?

--michael--
[e-mail]
=========================================================================
Date:         Sat, 3 Jul 1993 16:00:47 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Merging two tables in a query
In-Reply-To:  Message of Sat,
              3 Jul 1993 19:28:00 GMT from <CALLAHAN%DIALOGVM@MC IMAIL.COM>

Michael, I'll pull it down and put it up on CICA.  That is, if my Compuserve
isn't locked out because I'm playing "against the limit" on my credit card.

:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 3 Jul 1993 16:21:23 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      UNION.ZIP

Well, durn it, they've disabled uploads at CICA for the weekend.  I'll
UUencode it and put it up on the listserv for the brave souls amongst
us.

This will take a little while so have a nice holiday while u wait...:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 3 Jul 1993 18:49:55 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      UNION.MDB

OK, the UNION file that was discussed earlier is on the listserver as
a uuencoded file (UNION UUE) and can be retrieved with the command

GET UNION UUE

sent to [e-mail].

As mentioned before, I will also put it on CICA as soon as they turn
the uploads back on--probably Tuesday.

Happy 4th of July to our American subscribers (and a belated happy national
day to our friends in Canada as well!).

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 5 Jul 1993 18:43:33 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Mirrored/Alternative CICA sites

Regarding mirror sites for CICA, here's information from a
file called <ATTENTION_MIRROR_SITES> which was found in the
PUB/PC/WIN3 directory.  Unfortunately, it's dated sometime
in March, but should help for those times when CICA is a
little busy:

NORTH AMERICA
wuarchive.wustl.edu [128.252.135.4] in mirrors2/win3
grind.isca.uiowa.edu [128.255.19.233] in msdos/win3
gatekeeper.dec.com [16.1.0.2] in /.2/micro/msdos/win3

OVERSEAS
vmsa.technion.ac.il [132.68.7.2] (Israel Institute of Technology)
nic.switch.ch [130.59.1.40] (Switzerland)
monu6.cc.monash.edu.au [130.194.1.106] (Monash Univ Melbourne Austral)
nctuccca.edu.tw [140.111.3.21] (Chiao Tung Univ, Hsinchu, Taiwan)
src.doc.ic.ac.uk [146.169.2.1] (JANET mirror at Imperial College, London



As to why those who support "busy" sites don't put information like
this in the banner displayed when the "we're busy" message is
posted, I'll never know, but...

//
Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
CARmel, Indiana (carMEL is in California)
=========================================================================
Date:         Mon, 5 Jul 1993 17:29:07 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Information with 5 dimentions. How to?

Here's a question for Relational Gurus

I have an array of data in the current system that has 5 dimentions,
all independent of each other.  In every cell of this array there is
a value.  The question is -- how do I represent this information in
a relational system (i.e. Access) in the most effecient way in terms
of space and the access time (not very critical, but I'd like an
elegant solution).

Currently the array is starred in a file in the following facion:

For CalibType = 1 to 2
   For WireType = 1 to 4
      For Mode = 1 to 4
         For CheckPoint = 1 to 5
             Write #1, UpperLimit(...), LowerLimit(...)
         Next CheckPoint
      Next Mode
   Next WireType
Next CalibType

I used the actual variables to add meaning to the dimentions, maybe
that will inspire solution.
For those who are wanderin - this is from a telemetric application
where results of mesurments are analyzed against the Limits (which
this array represents).

Thanks for any comments/suggestions in advance

Dmitry

[e-mail]
=========================================================================
Date:         Tue, 6 Jul 1993 12:55:39 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Locking problem

Hi,

I have a serious problem with record locking but I don't know if this has
something to do with Access version 1.1.

a) When opening a form I initialize a query with user-related values
   (on open-function).
b) If the user clicks on one of the four listboxes of the form the same
query
   (RecordSource) is updated.
c) When clicking a command button I need to calculate another value that's
got to
   be put into a field of this query, but when trying to do:
    Ds1.Edit
   I always get the message: Couldn't update; the record is in use by
another
   session on the same machine.

As this isn't true I suspect that the record still is locked by the
"updating-session" of the form.

Some properties of the form are:
DefaultEditing: Allow Edits
Allow Editing : Available
Allow Updating: Any tables
Record Locks  : Edited Records

It looks a bit strange but when I do an Ds1.AddNew in the On Open-function
instead of an Ds1.Edit (to do this I first delete the record and then make
a new one) the Ds1.Edit statement in the function that runs after clicking
the command button works fine. Where's the difference? Doesn't the record
have to be locked after doing AddNew too?

My database is opened as shared.

Any hint appreciated!!

Martin
=========================================================================
Date:         Tue, 6 Jul 1993 11:32:59 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      BCNN Job Announcements

Someone recently asked about job opportunities and Access...

I've truncated the headers on the original not in the interest in
obscurity, but to prevent renegade messages...

Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana

---------- Forwarded Message ----------

> From: INTERNET:[e-mail],
INTERNET:[e-mail]
> To: [e-mail]
> Subject: BCNN Job Announcements
=========================================================================
Date:         Tue, 6 Jul 1993 18:49:03 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re: Information with 5 dimentions. How to?

On Mon, 5 Jul 1993 17:29:07 -0700, Dmitry Serebrennikov writes:

>I have an array of data in the current system that has 5 dimentions,
>all independent of each other.  In every cell of this array there is
>a value.  The question is -- how do I represent this information in
>a relational system (i.e. Access) in the most effecient way in terms
>of space and the access time (not very critical, but I'd like an
>elegant solution).

>Currently the array is starred in a file in the following facion:

>For CalibType = 1 to 2
>   For WireType = 1 to 4
>      For Mode = 1 to 4
>         For CheckPoint = 1 to 5
>             Write #1, UpperLimit(...), LowerLimit(...)
>         Next CheckPoint
>      Next Mode
>   Next WireType
>Next CalibType

It seems that for this data, you could use a single table, where each
column (field) is one of the dimensions, such as...

CalibType  WireType  Mode  CheckPoint  UpperLimit  LowerLimit
---------  --------  ----  ----------  ----------  ----------

Unless there are other pieces of information associated with the
various dimensions, you don't need multiple, linked tables, etc.
Crosstab queries would provide a useful way of looking at patterns
across more than one dimension at a time.

You might want to consider Lotus Improv, which is specifically designed
to store and manipulate this kind of multi-dimensional data very
easily.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 02:38:00 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         CALLAHAN <[e-mail]>
Subject:      Stuck on simple form design

I can't believe I am stuck on this. It must be easy. What I want is to
create a form to update a table so the user doesn't have to use the
datasheet view.

The table has only 3 fields: ID, Name, Description (ID is the key).
I want to mostly edit the Description (though all fields should be
editable) for a given Name. I don't want to scroll thru the records
to find the Name of interest, nor do I want to use the Find menu item.
I'd like to use a combo box to allow scrolling thru the list of Names
and when a name is picked have the matching record become current.
But I'd also like to enter a brand new name (no LimitToList allowed).

The combo box works, but of course it just updates the underlying
record, it doesn't move to the record for the given Name like using
the Find menu would.

Isn't it possible to do this on one form? Can I use/Do I need a
popup form for user input? (How?) Do I need to use subforms? Do I
need to use a query as a base rather than just the underlying table?

I'm completely blocked by this. It seems like it should be an easy
thing to do, but I can't see it. Any suggestions on how I can do
this would be appreciated. Thanks.

--michael--
[e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 15:11:39 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Stuck on simple form

Dear Michael,

You have to set the combo box property,After Update to Macro1 where
Macro1 updates ID,Name & Description. Microsoft Access doesn't updates ID,Name
& Description automatically.

If you want more details on how to define Macro1,
read Microsoft Access User's Guide  Pg 546.
There is an example on finding a record by Selecting a Value from a List.

Chor Ling
=========================================================================
Date:         Wed, 7 Jul 1993 11:58:30 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Not sure if this got to the list it bounced back!

*** Resending note of 06/30/93 23:02


Now that I have read the white paper I know what the problems are.

The note that I posted previously saying what the sequence of actions
is was correct. The problem comes when one wants to test the security
that one has set up. Testing can NOT be done using an unrestricted
copy of the work group that was used to generate the secure work group!

The part of the paper that gives us the clue is the part that says
"Gotcha: When you setup Microsoft Access, the User and Company names
are written to Disk #1. If you then give anyone.... The Admins group
in the system.mda that is created will have the same SID as the Admins
group in your system.mda. This means that anyone who uses that new
system.mda will have all the permissions that you do, in any databases
that you have permissioons....."

That basic problem is that when you spawn off work groups from the
same original system.mda then the ADMINS group will have the same
SID. This can be used to benefit if you want to have a global
DBA with rights in all workgroups. However it does mean that one
cannot afford to leave the original system.mda around in an unrestricted
state.

Basically the problem is that members of the ADMINS group have
the ability to acquire (grant to themselves ) permissions on
all tables that users create, so long as the table was created using
a work group with the same ADMINS SID.

There might still be a problem, I have not tested this yet.
You might not be able to clear out tables etc that have been created
by users who are unknown to you, wher ethat user started with
their own system.mda file and created a new secure work group and then
created a table in your database.

I hope that helps to make things clearer.
Anne

Thankyou
=========================================================================
Date:         Wed, 7 Jul 1993 06:18:11 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Not sure if this got to the list it bounced back!

> The part of the paper that gives us the clue is the part that says
> "Gotcha: When you setup Microsoft Access, the User and Company names
> are written to Disk #1. If you then give anyone.... The Admins group
> in the system.mda that is created will have the same SID as the Admins
> group in your system.mda. This means that anyone who uses that new
> system.mda will have all the permissions that you do, in any databases
> that you have permissioons....."

To avoid the problem of having User and Company Names propogated when using
one set of diskettes to install several users (you do have the correct number
of licenses, yes) use diskcopy to clone the first disk onto a blank diskette
(before doing any installs). You will have to do the disk copy each time you
install which will add about two minutes to each install.



-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 14:45:00 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         CALLAHAN <[e-mail]>
Subject:      Finding a record on a form

Yesterday I asked about using a form to finding a record and Chor
Ling directed me to page 546 of the User's Guide. Thank you! It was
exactly what I needed!

Well, it was *almost* exactly what I needed. This method duplicates
the control on the form. I could live with it, but not quite what I
wanted. Then this morning I had the opportunity to use a CompuServe
account and found a database that uses Access Basic to do the find
*without* duplicating the control.

The file is FNDREC.ZIP in Library 4 of the MSACCESS Forum. If there
is interest, I can UUEncode it (about 40K) and upload it to the list
since I don't have ftp capability.

--michael--
[e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 08:13:22 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Stuck on simple form design
In-Reply-To:  <[e-mail]>; from "CALLAHAN" at Jul 7,
              93 2:38 am

Michael,

Check out the NorthWind example that comes with Access, and look at the
Supplier Form. It has an example of a combo box doing just what you want,
to a point. Pay careful attention to the macros. Basically, what you want
is a NON-BOUND combo box. This means take out any Control Source in the
properties box. Make the record source the table (or query), usually can
be the same as the form.

The After Update macro should do 3 things:

1. GotoControl - specify the actual bound field here. In other words, if
   your combo box is called widget_combo or something, and there is an
   actual bound field called widget, then specify "widget" in this
   action.

2. FindRecord - use [widget_combo] as the parameter of what to search
   for. What you are doing is telling Access to look for the record that
   has whatever was selected out of the combo box.

3. GotoControl - this isn't necessary, but sometimes you want to finally
   pass focus to a certain control after the search is done.

The problem is that, while this works great, adding new records becomes
a real problem. I haven't entirely resolved that problem yet, but generally
I do use a pop-up window to accept input for a new record. I use a button
that says something like "add new" on it to allow the user to call up this
new-record popup. I then set LimitToList to Yes for the combo box.

One problem I am still having though, and so we'll turn this half-answer
into another question: does anyone have any good, clean examples of how
they keep someone from entering a new record at the end of the file, by
hitting PgDown, or tabbing past the last field/control? I haven't gotten
to the point where I need to worry about that just yet, since I am still
prototyping the application I am working on now, but I'll need to restrict
all new data entry to the popup window. It's far easier to control new
data entry through validation measures and such in a popup window than to
worry about both entry and editing in one window... :-)

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 7 Jul 1993 10:36:24 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Can record numbers be accessed?

I'v given up on this long time ago and found new ways to do the same,
but still, I can't belive that you can't get a number of the current
record in the table!  The same number that is usually displaied in the left
bottom corner of the form.  You can even edit it there (either with the mouse
or with a special F-key donno which).  There is a macro action "goto to record"
that takes the same number and gets you to that record. However I could not
find any way to get to this number from either a macro or Basic code.
That is short of send-keying the F-Key to goto that box, then Copy, then go to
an unbound controll, paste and get the value -- Gee there's got to be an easier
way!  Don't you think?

Dmitry
[e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 11:26:08 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         richard dixon <[e-mail]>
Subject:      ACCESS DEVELPOMENT KIT

Folks:

Beyond the MS Press Release for the ACCESS DEVELOPMENT KIT and one feeble
advertisement in *Access Advisor* I have found little info on The Kit.

Has anyone seen it for sale yet?

The press release referred to some custom tools for user help, custom forms
and icons but I have not yet learned technical info like *how much
addition free disk space might be needed?*

I am curious whether the addition of VB 3.0 Pro (to ACCESS with
The Kit) will offer any benefit or whether The Kit replaces most of what VB
could do for our general development purposes in ACCESS.

Will someone keep us abreast?  If this info is archived, please advise.

Thanks in advance,
Richard
[e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 12:52:36 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: ACCESS DEVELPOMENT KIT
In-Reply-To:  Message of Wed,
              7 Jul 1993 11:26:08 -0600 from <[e-mail] .UTAH.EDU>

There was some chatter on CompuServe about the ADK but I am nowhere near
where I can hook into CServe and shoot it over here.  Can someone else
summarize?  I remember people were saying it was available in various
places for a lot less than the $495 list.

BTW, VB 3.0 is not a one-to-one substitute for the ADK or for Access 1.1,
as has already been discussed here.  As far as free disk space, the specs
on VB 3.0 indicate a need for 12MB free for Standard Edition and 32MB free
for the Professional Edition.  That seems like a lot to me but I don't
have the specs for the ADK to compare.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 7 Jul 1993 12:56:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: ACCESS DEVELPOMENT KIT
In-Reply-To:  Message of Wed,
              7 Jul 1993 11:26:08 -0600 from <[e-mail] .UTAH.EDU>

(oops) forgot one thing--I have NOT seen the ADK locally.  That
much I know for sure...but I haven't seen the 1.1 upgrade either.

Interestingly enough, I HAVE seen lots of copies of VB 3.0 on the shelf....:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 7 Jul 1993 11:00:03 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: ACCESS DEVELPOMENT KIT

>
>
> I am curious whether the addition of VB 3.0 Pro (to ACCESS with
> The Kit) will offer any benefit or whether The Kit replaces most of what VB
> could do for our general development purposes in ACCESS.
>
I was not aware that VB 3.0 Pro came with the Access Development Kit. In fact it
 is
the Access 1.1 engine that is included in VB 3.0. You can certainly create Acces
s aware
applications using VB 3.0. If you get the Pro version they include a data contro
l
object that allows for easy use of Access (or other dbs) tables.

If you have VB 3.0 you don't need the ADK and vice-versa. Although, there is no
reason
that you can't have both except $.

MS Shows recently announced seminars that will 'teach' Access programming. The f
ee is $249
and you get a FREE copy of the ADK. The SRP of the ADK is $495, so this might be
 a deal!!
Microsoft says in the brochure that they will even PROVIDE LUNCH.



-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 13:03:54 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Quarterly FAQ distribution

ACCESS-L FAQ (Frequently-Asked Questions)
For ACCESS-L@INDYCMS, Microsoft Access Database Discussion List
Version 1.0, 7/7/93
============================================================
This FAQ will be posted to the list at large on a quarterly
basis.
It can be retrieved at any time from LISTSERV@INDYCMS with
the command GET ACCESS-L FAQ.
Suggestions for content to [e-mail]
============================================================

Q. What is ACCESS-L?

A. ACCESS-L@INDYCMS is a BITNET distribution list running
   under LISTSERV 1.7f at INDYCMS, the VM computer at
   Indiana University Purdue University Indianapolis.
   ACCESS-L is provided for the discussion of Microsoft
   Access, a relational database product for Microsoft
   Windows 3.x.

   DISCLAIMER:  Indiana University is <not responsible> for
   either the content or the management of the list.  The
   list administrator's responsibilities are limited to
   keeping the list focused and tending to various
   administrative duties related to the list.  Those who
   post to ACCESS-L are solely responsible for the content
   of their posts.  Any and all software, either posted
   across ACCESS-L or residing in the list archives is
   downloaded and used at the downloader's own risk.

   Note that there are THREE ACCESS-L lists on BITNET.  One
   is ACCESS-L@INDYCMS, this list; one is ACCESS-L@BRUFPB,
   a Brazilian Microsoft Access list (one assumes without
   supporting data that it is in Portugese); and the last
   is ACCESS-L@UNBVM1, which has nothing to do with
   Microsoft Access at all.


============================================================
Q. Does Microsoft Corporation sponsor ACCESS-L?

A. No.  The list is not sponsored in any way by Microsoft,
   although Microsoft employees and particularly Access
   design staff are welcome and encouraged to subscribe.


============================================================
Q. What is the format for sending commands to LISTSERV?

A. First of all, be sure you send them to LISTSERV and not
   to the list.  Second, there are two ways to send the
   commands:  Interactively and via Mail.

   Interactive commands differ between systems (and are not
   available on all systems anyway--e.g., AOL and
   CompuServe).  They would be of the general format:

    (For VM/CMS:)  TELL LISTSERV AT INDYCMS <command>

    (For VAX/VMS:) SEND LISTSERV@INDYCMS <command>

    For other systems, see your consultants.  For specifics
     on LISTSERV commands, send the command GET LISTSERV
     REFCARD to LISTSERV@INDYCMS.

   Mail commands can be more efficient if the network is
   experiencing its usual glitches--at least the command
   will eventually be processed by LISTSERV.  To send
   commands by mail, simply address a message to
   LISTSERV@INDYCMS (or [e-mail]) with a
   blank subject line and the command you want to send as
   the body of the message.  You can send up to five
   commands at a time in this way, but be forewarned--if
   one of the commands triggers an error, all subsequent
   commands in the message will be flushed without being
   processed.  (LISTSERV will count your signature line (if
   any) as an error but this should not cause a problem
   since it comes last.)


============================================================
Q. How do I subscribe to or unsubscribe from ACCESS-L?

A. To subscribe to ACCESS-L, send the command

   SUB ACCESS-L <Your_Name>

   to [e-mail].

   To unsubscribe from ACCESS-L, send the command

   UNSUB ACCESS-L

   to [e-mail].


============================================================
Q. What if I try to unsubscribe and am told I do not appear
   in the list?

A. You are either a) subscribed via a redistribution list
   (such as MS-ACCESS) or b) your Internet address has
   changed slightly and LISTSERV does not recognize your
   ID.  You can get a copy of the subscriber list by
   sending the command REV ACCESS-L to LISTSERV@INDYCMS.
   If you can't figure the problem out, do <NOT> post a
   message to the list at large to unsubscribe you.  Send
   all such mail directly to the list administrator.  See
   below.


============================================================
Q. Somehow I got my hands on this FAQ but I can't seem to
   get a reaction from the listserver when I try to
   subscribe.  Why is that?

A. ACCESS-L is set up to confirm a mailing path back to all
   new subscribers.  This is done by sending a message back
   to the address on the subscription request which has a
   unique confirmation code.  The subscriber is asked to
   forward that confirmation code back to LISTSERV.
   Because some Internet gateways aren't always two-way,
   your confirmation message probably did not get back to
   you, meaning that LISTSERV could not send you mail even
   if the list administrator added you manually.  This is a
   network problem and isn't currently solvable unless you
   can provide a substitute (i.e., BITNET) address.  You might
   try subscribing from another account or subscribing to a
   redistribution list.


============================================================
Q. Who is the list administrator and how do I contact him?
A. The list administrator is Nathan Brindle,
   NBRINDLE@INDYCMS.  His Internet address is
   [e-mail].


============================================================
Q. How do I get a copy of old postings (list archives)?

A. Send the command GET ACCESS-L LOGYYMM to
   LISTSERV@INDYCMS, where YYMM is the year and month of
   the archive you want (i.e., LOG9302 is for February
   1993).


============================================================
Q. How do I get an index of list archives and other files
   related to the list?

A. Send the command IND ACCESS-L to LISTSERV@INDYCMS.


============================================================
Q. If I want to FTP files associated with ACCESS-L rather
   than request them through the listserver, how do I do
   that?

A. At the moment, the list administrator is "mirroring" all
   files from the list archives (except for the message
   logs themselves) to FTP.CICA.INDIANA.EDU.  This may
   change, but for the moment it's all we can do.  Newer
   files are located in the pub/pc/win3/uploads directory
   there; older ones will be relocated at some point by
   CICA into pub/pc/win3/access.  Naturally you should feel
   free to use CICA's mirror sites as well.


============================================================
Q. I have a GREAT .MDB to share with everyone on the list.
   If I uuencode it, should I send it to the list?

A. Those conversant with netiquette would probably reply in
   the negative.  Even the smallest .MDB is going to be
   larger than most people want to find in their mailbox,
   particularly since the file is going to be somewhat
   larger than it would be in binary format anyway.  Also
   remember that some people are paying for their messages
   and may not be particularly appreciative of receiving a
   long file they didn't ask for; and not everyone has
   UUdecoding software, either.

   If you wish to share a file with the rest of the list,
   you are encouraged to upload it to CICA or to send it to
   the list administrator in private mail with a request
   that he include it in the list archives.  (Such requests
   should include an abstract of what the file does and/or
   what it includes.)

   Also, because the list is "digestified" and digests
   typically truncate at 1000 or 1500 lines, you may crowd
   some posts out with a long UUencoded message.  There
   have also been reports from people on America Online
   that long posts from the Internet are usually cut short
   on their service.


============================================================
Q. I've found a review or article in a computer magazine
   that relates to a discussion taking place.  May I post
   the review or article to the list?

A. If you can summarize the review or article in your own
   words, feel free to do so.  Otherwise, please refrain
   from posting copyrighted materials to the list.  (You
   can always cite the article in question so others can
   look it up.)

*END OF FILE*

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 7 Jul 1993 11:02:36 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: ACCESS DEVELPOMENT KIT

>
> BTW, VB 3.0 is not a one-to-one substitute for the ADK or for Access 1.1,
> as has already been discussed here.  As far as free disk space, the specs
> on VB 3.0 indicate a need for 12MB free for Standard Edition and 32MB free
> for the Professional Edition.  That seems like a lot to me but I don't
> have the specs for the ADK to compare.
>
These requirements are for the machine on which you are doing your development.
The machines may or may not be the same machines on which the applications run.
If the applications run on other machines then the space needed is only for the
VBRUN(?).DLL and you application EXE. That space will be much less than 12 M
unless you have huge applications.


-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Wed, 7 Jul 1993 14:02:40 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      +Postage Due+Can record numbers be accessed?

>I'v given up on this long time ago and found new ways to do the same,
>but still, I can't belive that you can't get a number of the current
>record in the table!  The same number that is usually displaied in the left
>bottom corner of the form.  You can even edit it there (either with the mouse
>or with a special F-key donno which).  There is a macro action "goto to record"
>that takes the same number and gets you to that record. However I could not
>find any way to get to this number from either a macro or Basic code.
>That is short of send-keying the F-Key to goto that box, then Copy, then go to
>an unbound controll, paste and get the value -- Gee there's got to be an easier
>way!  Don't you think?

Dmitry,

Don't kill yourself looking for something which isn't there -- I raised this
 issue on
Compu$erve in about November of last year.  Interestingly enough, there were
many cries of "in a relational system, knowing the record number is 1)
 irrelevant; and
2) of no value since the order of the records is so volatile..." (or some such
 drivel).
Said persons were very quiet when I pointed out (that) the record number appears
in table views...


Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Wed, 7 Jul 1993 14:19:30 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      Re: Can record numbers be accessed?
In-Reply-To:  Message of Wed,
              7 Jul 1993 10:36:24 -0700 from <[e-mail]>

Have you tried to create a variable called Totalcount a set it equal to
Lastrow of table?  Maybe using snapshot or Dyanset.
                                             Regards,
                                                     Greg
=========================================================================
Date:         Wed, 7 Jul 1993 14:24:24 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      +Postage Due+ACCESS DEVELPOMENT KIT

> Beyond the MS Press Release for the ACCESS DEVELOPMENT KIT and one feeble
> advertisement in *Access Advisor* I have found little info on The Kit.
>
> Has anyone seen it for sale yet?
>
> The press release referred to some custom tools for user help, custom
forms
> and icons but I have not yet learned technical info like *how much
> addition free disk space might be needed?*
>
>I am curious whether the addition of VB 3.0 Pro (to ACCESS with
> The Kit) will offer any benefit or whether The Kit replaces most of what
VB
> could do for our general development purposes in ACCESS.

I cannot attest to availability but I can correct one (albeit minour)
error:

It's <Access Distribution Kit> not <Development>.

The most current information I have is (that) it is a one-time charge of
$495 which allows you to package it with your Access applications for
distribution royalty-free.  Setup procedures, etc. are included.

I've not looked at it recently (been too busy doing books, including an
Access Developer's Guide, which covers topics like this -- I'd say more,
but I don't want to invoke the wrath of the network police for promoting
one of our books) so I don't remember space requirements.

Also, the ADK is one of the reasons you should consider using modules
instead of macros for anything you intend to distribute.  Macros don't have
error trapping so an error will either freeze or abort Access when using
the ADK.

Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Wed, 7 Jul 1993 14:29:24 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Preventing new records

A solution was posted to Compu$erve back in February.  Unfortunately, I
didn't save the name of the author and as I checked the library there, his
name is not on it.  Here's the source for what he considered to be a kludge
(I thought it was rather innovative).  I trust this will help.

Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana

----------------------------start here-------------------------------
Function PreventNew (aForm As Form)
' Keep the user from positioning himself to the new
' blank record, thus preventing the adding of records.
' To use, set the form's OnCurrent event to
'   =PreventNew(Form)
' If you already have a macro attached to onCurrent,
' add a reference to this Function in your macro.

    If AtNewRecord(aForm) And aForm.dynaset.RecordCount > 0 Then
        aForm.dynaset.MoveLast
        aForm.Bookmark = aForm.dynaset.Bookmark
    End If
End Function
---------------------------break here--------------------------------
Private Function AtNewRecord (aForm As Form) As Integer
    Dim temp As Variant

    On Error GoTo atNew

    temp = aForm.Bookmark
    AtNewRecord = False
    Exit Function

atNew:

    AtNewRecord = True
    Exit Function

End Function
---------------------------------end here----------------------------

=========================================================================
Date:         Wed, 7 Jul 1993 14:45:11 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Gordon Charrick <[e-mail]>
Subject:      Lines in a Wizard report

I created a report (group/total) using Wizard. I chose no grouping or
sorting in the report itself since I did all that in the query that I used
as the data source for the report. The report basically just dumped out a
sorted database with no calculations or totals or anything. I used ledger
style, by the way.

When I previewed the report, everything looked okay (there are lines
between each line and each field). When I printed it out on my Laserjet 3P,
lines didn't appear between each line. The lines were in some sort of
pattern that changed depending on the margins. If I used the default 1"
margins all around the lines "grouped" the data in a pattern of 1, 2, 2, 2,
3, 2, 2, 2 repeating. Has anyone seen anything like this? I couldn't find
anything in the manual and I have to admit I'm just learning the system.

Gordon
=========================================================================
Date:         Wed, 7 Jul 1993 12:23:04 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: +Postage Due+ACCESS DEVELPOMENT KIT
In-Reply-To:  <[e-mail]>; from "Phillip" at Jul 7,
              93 2:24 pm

We have the Access DISTRIBUTION kit in, and it in no way has ANYTHING
to do with VB3.0. VB3.0 does not create run-time Access applications,
which is what ADK does. The ONLY connection between VB3.0 and
Access 1.1 is that the former contains the latter's engine. And, aside
from the fact that AccessBASIC resembles VisualBasic, that's it...
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 7 Jul 1993 13:46:40 -0600
Reply-To:     richard dixon <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         richard dixon <[e-mail]>
Subject:      Re: ACCESS DEVELPOMENT KIT
In-Reply-To:  <[e-mail]>

On Wed, 7 Jul 1993, Morris Myers wrote:

>I was not aware that VB 3.0 Pro came with the Access Development Kit.

I have not expressed my question well.  I am wondering how well the ADK
will compare with VB in creating a unique user interface.

> If you have VB 3.0 you don't need the ADK and vice-versa. Although, there is n
   o
> reason that you can't have both except $.

I guess this is my real question.  VB is very capable of driving ACCESS.
VB distributes royalty-free (@$495.). Access requires the ADK (@$495.) for
distribution.  If ACCESS were royalty free would we realize any benefit by
purchasing VB over the ADK?

That is, if there are features in VB that are missing in ADK it would
cost 3x$495 (suggested) to purchase those VB features and distribute ACCESS.

I am not questioning MS's pricing or marketing techniques -- I am just
trying to understand EXACTLY what the ADK does and if, in fact, many of us
will be budgeting for VB PRO also.  We have seen entire specs and
features for VB and ACCESS 1.1 but MS has not yet been completely
forthcoming as regards the ADK.

> and you get a FREE copy of the ADK. The SRP of the ADK is $495, so this might
   be
>  a deal!!
> Microsoft says in the brochure that they will even PROVIDE LUNCH.

There is no free lunch in America or, at least, so I've heard.  This is
interesting.  I will keep my eyes open for this.

By the way, I am a new subscriber (I am also new to RDB) and I have been a
passive *listener* for the past few days.  My development is still in the
concept stage (that is, I am still reading the documentation and creating
the basic forms, etc. on the machine).

Because I am TOO new at this my questions will far exceed the answers that
I will be able to provide.  If some of you will just point me in the right
direction once in a while... I don't expect the group to write my app for me.

Thanks,
Richard
[e-mail]
___________________________________________________________________________
"He who fears corruption, fears life."  Saul Alinsky
=========================================================================
Date:         Wed, 7 Jul 1993 14:26:25 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         Jack Wiercinski <[e-mail]>
Subject:      How to prevent adding a new record to database

Tony Hamilton asks about that. Someone posted on Compuserve a sample code
which addresses that problem. (Access Forum Library , file NONEW.MDB)
For benefit of those who have no access to Compuserve here is the code:

FUNCTION PREVENTNEW (AFORM AS FORM)
'KEEP THE USER FROM POSITIONING HIMSELF TO THE NEW
' BLANK RECORD, THUS PREVENTING THE ADDING OF RECORDS.
' TO USE, SET THE FORM'S ONCURRENT EVENT TO
'  =PREVENTNEW(FORM)
' IF YOU ALREADY HAVE A MACRO ATTACHED TO ONCURRENT,
' ADD A REFERENCE TO THIS FUNCTION IN YOUR MACRO
    IF ATNEWRECORD(AFORM) AND AFORM.DYNASET.RECORDCOUNT > 0 THEN
        AFORM.DYNASET.MOVELAST
        AFORM.BOOKMARK = AFORM.DYNASET.BOOKMARK
    END IF
END FUNCTION
----------------
PRIVATE FUNCTION ATNEWRECORD (AFORM AS FORM) AS INTEGER
DIM TEMP AS VARIANT
ON ERROR GOTO ATNEW
TEMP = AFORM.BOOKMARK
    ATNEWRECORD = FALSE
    EXIT FUNCTION
ATNEW:
    ATNEWRECORD = TRUE
    EXIT FUNCTION
END FUNCTION
-------------------
It works like charm... credits to the unknown author.
My apology for the code capital letters. I just can't figure out our
mainframe editor <g>.

Jack                                    ISD NAIT [phone]
=========================================================================
Date:         Wed, 7 Jul 1993 14:50:03 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Preventing new records
In-Reply-To:  <[e-mail]>; from "Phillip" at Jul 7,
              93 2:29 pm

Thank you Jack and Philip for posting the "kludge" for disallowing adding
new records. It looks like it will work. Was hoping for something cleaner,
but it looks like a simple solution is the exception with Access...

Thanks again.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 8 Jul 1993 11:20:01 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: Stuck on simple form design

Once you have found the name on the list, run a macro that moves to the
name control on the form and requeries the control making it equal
to the value in the browse/pick list.
Cheers.
=========================================================================
Date:         Wed, 7 Jul 1993 22:34:13 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Tab order - tab elimination?
In-Reply-To:  <[e-mail]>; from "Phillip" at Jul 7,
              93 2:29 pm

Curious...

I have controls on my forms that need to be active, like push buttons,
but which I do NOT want the user to be able to TAB to. Actually, its not
a matter of needing to restrict this, it's just simply damn annoying as
a user to have to tab through all the combo boxes and push buttons on a
form just to get the next record... (in situations where you might do a
lot of data entry, and moving from the last field of one record should lead
you right into the first of the next). I just happen to have a few buttons
and things for certain options on these data entry forms. My solution right
now is to just explain to the users (beta-testers right now) that they should
get used to using PgDwn to get to the next record.

Called Microsoft, and they could only think of the one thing I already did,
which doesn't work. Thought of using the OnEnter event to move focus to
another control. The problem is that you _need_ to enter the control to use
it - I just want entry to these specific controls to be mouse only. Oh yes,
if the controls are kept in a separate section, like the header or footer,
then you're back in business, since there is a separate tab order for each
section. However, this doesn't work on my forms. I've tried redesigning the
forms to work around the limitations, but then I lose all the effectiveness
I designed into the forms in the first place. WHen I design a form, I try
to make it as natural and intuitive as possible. Access seems to be
fighting me every step of the way ... :-)

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 8 Jul 1993 09:48:18 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      "Record numbers" ... or almost...

I once also thought about the problem of "record numbers", discussed here
during the last couple of days, without solution. Now I have a different
problem, which is a bit similiar:

I have a select query, which pick's from a big database let's say 100
records and puts them into certain order (ascending according to one
record). That all works fine, but I'd like to get the "record number" in
that query, i.e. what is it's order number out of those 100 records.
(I hope I could explain the problem clearly enough...)

Anyone got an idea how to do it?


Thanks in advance and g'day!
Pekka
=========================================================================
Date:         Thu, 8 Jul 1993 09:33:03 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Re: "Record numbers" ... PERFORMANCE

Pekka,

would it be a solution for you if you put all your sorted records in a
table where you can also put any number you like?

Maybe the following could also be of interest for your problem...

We have successfully avoided to use large (rather complex than large!)
queries for reports and have put all the records for the query that the
report is based on into a special table.

One report took more than 4 (!) hours to print 7 pages, then we made a
rather short Basic-function which reads the underlying queries one time and
writes the results into a table and now the same reports with more features
than before takes 6 minutes (for 14 pages caused by more records and more
sorting and grouping!!).

The first version of the report used sub-reports and we found that for
every printed field of the table Access made every query from the
beginning.

Maybe someone could tell of this is an SQL-"feature" or the fault of
Access??

Regards

Martin
=========================================================================
Date:         Thu, 8 Jul 1993 11:12:01 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Tabs in Statusline?

Hi to all on Access-l and MS-Access!

Is there a way to use Tabs while putting something into the statusline?
I would like to have output liek this:

1 of 200   Smith     1.1.94
2 of 200   Roberts   5.2.94
3 of ....

I suppose it isn't possible but maybe someone has a hint...

Thanks in advance!

Martin
=========================================================================
Date:         Thu, 8 Jul 1993 09:37:07 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: "Record numbers" ... PERFORMANCE

> One report took more than 4 (!) hours to print 7 pages, then we made a
> rather short Basic-function which reads the underlying queries one time and
> writes the results into a table and now the same reports with more features
> than before takes 6 minutes (for 14 pages caused by more records and more
> sorting and grouping!!).

> The first version of the report used sub-reports and we found that for
> every printed field of the table Access made every query from the
> beginning.
>
> Maybe someone could tell of this is an SQL-"feature" or the fault of
> Access??

Martin, stories like this are not that rare:  (not regarding Access, but
 computers in general).  Another similar
situation is when one forgets to reverse the subscripts in a FORTRAN array --
 projects which would take
hours before would then take only minutes.
=========================================================================
Date:         Thu, 8 Jul 1993 16:30:06 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Is SQL economic?

Hi Philip, hi to all on the lists,

When looking at the way Access performs the same query hundreds of times
for ONE (!!!) report one can only be amazed that there even is a printer
output after hours.

But: So far as we have seen everyone of those joins that Access make really
DOES NOT look very economically!! I have seen that one can use one
sql-query as the input for another one (in PROGRESS) which looks much
better than any of those joins because not so many data have to be moved.

Are there more of you who have made similar experiences?

Regards

Martin
=========================================================================
Date:         Thu, 8 Jul 1993 09:11:40 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         Jack Wiercinski <[e-mail]>
Subject:      Tab Order - Tab elimination question.

MS Access is coming with the file PSSKB.TXT (Commonly asked questions).
Question #13 deals with Tab elimination issue, basically through Locked and
Enable properties to prevent a field to be included in the Tab order.
You might find it useful.

Jack                                    ISD NAIT [phone]
=========================================================================
Date:         Thu, 8 Jul 1993 08:54:31 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Index and Primary Indexes

I'm trying to trap some of the error messages that are generated by
indexes.  I'd like to be able to tell the user through a message box what
field was left null, or what field was a duplicate.

Does anyone have any ideas if this can be done?

_________________________________________
Glendale Community College - Bill Stewart
6000 W. Olive Ave.
Glendale, Az. 85302
[phone]
_________________________________________
=========================================================================
Date:         Thu, 8 Jul 1993 09:05:20 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Index and Primary Indexes
In-Reply-To:  <[e-mail]>; from "Bill Stewart" at Jul
              8, 93 8:54 am

For canned applications, Access' own messages aren't the greatest. My
solution is to disable enforced referential integrity for one, and to
do all the validation in event macros or functions by hand. In some cases
it is easy to get your message to the user before the system would normally
do it, in others it is not so easy, and in some cases I still haven't
figured out a good way to eliminate the chance that a user will get such
a system message. It just takes persistence and a lot of experimentation
with validations in the BeforeUpdate, AfterUpdate, OnCurrent, and so forth
kind of events...
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 8 Jul 1993 11:10:22 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: How to prevent adding a new record to database

  A simpler method is available if you have your table set up so that a
particular field is NEVER NULL in existing records, and ALWAYS NULL in the
new record.  I used a field called "added" which contains the date/time
the record was created.  This is set to Now() in a "Before Update" routine
when records are added (you know it is a new record in the "Before Update"
routine because [added] is null).
  To prevent addition of new records from a particular form, you can call
the following function from "On Current":

Function RecNoAdd(MyTestField As Control)
  If IsNull([MyTestField])
    DoCmd GoToRecord , , A_PREV
  End If
End Function

               ... [e-mail]


[e-mail] Wrote:
|
|
| Tony Hamilton asks about that. Someone posted on Compuserve a
| sample code
| which addresses that problem. (Access Forum Library , file
| NONEW.MDB)
| For benefit of those who have no access to Compuserve here is
| the code:
|
| FUNCTION PREVENTNEW (AFORM AS FORM)
| 'KEEP THE USER FROM POSITIONING HIMSELF TO THE NEW
| ' BLANK RECORD, THUS PREVENTING THE ADDING OF RECORDS.
| ' TO USE, SET THE FORM'S ONCURRENT EVENT TO
| '  =PREVENTNEW(FORM)
| ' IF YOU ALREADY HAVE A MACRO ATTACHED TO ONCURRENT,
| ' ADD A REFERENCE TO THIS FUNCTION IN YOUR MACRO
|     IF ATNEWRECORD(AFORM) AND AFORM.DYNASET.RECORDCOUNT > 0
| THEN
|         AFORM.DYNASET.MOVELAST
|         AFORM.BOOKMARK = AFORM.DYNASET.BOOKMARK
|     END IF
| END FUNCTION
| ----------------
| PRIVATE FUNCTION ATNEWRECORD (AFORM AS FORM) AS INTEGER
| DIM TEMP AS VARIANT
| ON ERROR GOTO ATNEW
| TEMP = AFORM.BOOKMARK
|     ATNEWRECORD = FALSE
|     EXIT FUNCTION
| ATNEW:
|     ATNEWRECORD = TRUE
|     EXIT FUNCTION
| END FUNCTION
| -------------------
| It works like charm... credits to the unknown author.
| My apology for the code capital letters. I just can't figure
| out our
| mainframe editor <g>.
|
| Jack                                    ISD NAIT (403)
| 471-8617
|
|
=========================================================================
Date:         Thu, 8 Jul 1993 13:19:16 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: How to prevent adding a new record to database
In-Reply-To:  <[e-mail]>; from
              "Jeff=[e-mail]" at Jul 8, 93 11:10 am

>   A simpler method is available if you have your table set up so that a
> particular field is NEVER NULL in existing records, and ALWAYS NULL in the
> new record.  I used a field called "added" which contains the date/time
> the record was created.  This is set to Now() in a "Before Update" routine
> when records are added (you know it is a new record in the "Before Update"
> routine because [added] is null).
>   To prevent addition of new records from a particular form, you can call
> the following function from "On Current":
>
> Function RecNoAdd(MyTestField As Control)
>   If IsNull([MyTestField])
>     DoCmd GoToRecord , , A_PREV
>   End If
> End Function
>
>                ... [e-mail]

Two questions:

If your database is designed such that the given table has certain fields
that must always be filled anyway (checked for in a data-entry form), you
could just use one of these fields, right?

Also, what is A_PREV?

Tony Hamilton
[e-mail]
=========================================================================
Date:         Thu, 8 Jul 1993 16:48:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      How to prevent adding a new record to database

>   A simpler method is available if you have your table set up so that a
>particular field is NEVER NULL in existing records, and ALWAYS NULL in the
>new record.  I used a field called "added" which contains the date/time
>the record was created.  This is set to Now() in a "Before Update" routine
>when records are added (you know it is a new record in the "Before Update"
>routine because [added] is null).
>  To prevent addition of new records from a particular form, you can call
>the following function from "On Current":
>
>Function RecNoAdd(MyTestField As Control)
>  If IsNull([MyTestField])
>    DoCmd GoToRecord , , A_PREV
>  End If
>End Function


The primary drawback to this would be in a large environment -- the cumulative
 effect of a couple of extra
bytes on every record could be a lot of bloat, especially if any effort has gone
 into getting everything into
fifth normal and...


Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 8 Jul 1993 16:54:30 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: How to prevent adding a new record to database

.
.
.
>
> Function RecNoAdd(MyTestField As Control)
>   If IsNull([MyTestField])
>     DoCmd GoToRecord , , A_PREV
>   End If
> End Function
>
>                ... [e-mail]

% Two questions:

% Also, what is A_PREV?

short for A_PREVIOUS.

Rather than repeat the docs, look at the online help under "gotorecord action"
 and select "Access Basic"
when you have the option (it's next to "example")



Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 8 Jul 1993 20:13:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Norman E. Powroz" <[e-mail]>
Subject:      Re: Not sure if this got to the list it bounced back!
In-Reply-To:  Message of 7 Jul 93 09:18 EDT from "Morris Myers"

> > The part of the paper that gives us the clue is the part that says
> > "Gotcha: When you setup Microsoft Access, the User and Company names
> > are written to Disk #1. If you then give anyone.... The Admins group
> > in the system.mda that is created will have the same SID as the Admins
> > group in your system.mda. This means that anyone who uses that new
> > system.mda will have all the permissions that you do, in any databases
> > that you have permissioons....."
>
> To avoid the problem of having User and Company Names propogated when using
> one set of diskettes to install several users (you do have the correct number
> of licenses, yes) use diskcopy to clone the first disk onto a blank diskette
> (before doing any installs). You will have to do the disk copy each time you
> install which will add about two minutes to each install.


Actually, it's not necessary to clone the entire diskette.  All you need
to copy is the SETUP.INI file.  Microsoft's setup program writes the
name and company information into the SETUP.INI file when you first
install the software package (works for every MS application I have seen
so far, including Foxpro)

HTH
Norm
=========================================================================
Date:         Fri, 9 Jul 1993 11:55:54 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Use of Macro set-value in Form

Have anyone tried to use macro to open a form in edit mode and set one of the
field in the form to system date ie Macro setvalue [fieldname] =Date()

???

I tried. However, the field is not set to system date but another value.
I single-step through the macro. The argument in Macro set-value is system
date BUT the value that appears on the form is another date.

HELP ... Does anyone know why ???

Chor Ling
[e-mail]
=========================================================================
Date:         Fri, 9 Jul 1993 14:50:52 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: Use of Macro set-value in Form

try using the format() function on the date
e.g.  setvalue [fieldname] = format(Date(),"d/mmm/yy")

Cheers.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Fri, 9 Jul 1993 10:03:36 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      PSSKB.TXT (Commonly asked questions)

On Thu, 8 Jul 1993 09:11:40 MDT, Jack Wiercinski wrote:

>MS Access is coming with the file PSSKB.TXT (Commonly asked questions).
>Question #13 deals with Tab elimination issue, basically through Locked and
>Enable properties to prevent a field to be included in the Tab order.
>You might find it useful.
>
>Jack                                    ISD NAIT [phone]

Where can you get that PSSKB.TXT???? Compuserv???

Pekka

***********************************************************************
 Pekka Koskinen                 :)
 CIMO, P.O. Box 343             :)  "I'd rather be the last of the
 00531 Helsinki, FINLAND        :)   men of Marathon than the first
 tel [phone]        :)     of the men of Auschwitz."
 fax [phone]        :)      (Unknown philosopher)
=========================================================================
Date:         Fri, 9 Jul 1993 00:37:02 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Error Traping and the like

>
> I'm trying to trap some of the error messages that are generated by
> indexes.  I'd like to be able to tell the user through a message box what
> field was left null, or what field was a duplicate.
>
> Does anyone have any ideas if this can be done?
>

        The only solution I have for this and in general Access error handling
        is to trap MicroSoft's internal error codes and interpret them
        yourself.  You set up an error handler (look for help on "On Error")
        and in there bringup a MsgBox with some stupid text like:
        "Oo-ps :" + Str$(Err)

        this will show in the message box the word Oo-ps and then a number.
        Write down that number -- that is the error code for whatever error
        had just happened. Not you can trap it in the same Error handler likeso
        Select Case Err
            Case 21341
                'Got ya! Invalid this and that...
            Case else
                MsgBox("System Error "+str$(Err))
        End Select

        Or something of this order. You can probably make it so that Microsoft's
        messages are displaied if it is the "case else".  I think if you do
        Error Err
        inside your own errorhandler that will provoke Microsoft to kick in,
        but I am not sure about this.

        A word of causion:  I heard that these error codes are not nesseseraly
        kept consistent across virsions!!!  They are definetely not documented.
        On the other hand this is the only way I know to do any kind of error
        traping at all.

Good luck.
Dmitry
[e-mail]
=========================================================================
Date:         Fri, 9 Jul 1993 00:38:57 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Setting Form's field to a Date()

> Have anyone tried to use macro to open a form in edit mode and set one of the
> field in the form to system date ie Macro setvalue [fieldname] =Date()
>
> ???
>
> I tried. However, the field is not set to system date but another value.
> I single-step through the macro. The argument in Macro set-value is system
> date BUT the value that appears on the form is another date.
>
        I bet you're getting December 31, 1899 ?...
        It's a common thing:  you can't use '=' with Date() and Time() functions
        Just use Date() instead of =Date() in the argument.

[e-mail]
=========================================================================
Date:         Fri, 9 Jul 1993 07:22:27 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      PSSKB.TXT (Commonly asked questions)

On Thu, 8 Jul 1993 09:11:40 MDT, Jack Wiercinski wrote:

>MS Access is coming with the file PSSKB.TXT (Commonly asked questions).
>Question #13 deals with Tab elimination issue, basically through Locked and
>Enable properties to prevent a field to be included in the Tab order.
>You might find it useful.
>
>Jack                                    ISD NAIT [phone]

Where can you get that PSSKB.TXT???? Compuserv???

Pekka

*********


The PSSKB.TXT file comes with MS-Access. It should be on your "\ACCESS"
directory

Dave F.
=========================================================================
Date:         Fri, 9 Jul 1993 08:20:20 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: How to prevent adding a new record to database

[e-mail] Wrote:
|
|
| >   A simpler method is available if you have your table set
| up so that a
| > particular field is NEVER NULL in existing records, and
| ALWAYS NULL in the
| > new record.  I used a field called "added" which contains
| the date/time
| > the record was created.  This is set to Now() in a "Before
| Update" routine
| > when records are added (you know it is a new record in the
| "Before Update"
| > routine because [added] is null).
| >   To prevent addition of new records from a particular
| form, you can call
| > the following function from "On Current":
| >
| > Function RecNoAdd(MyTestField As Control)
| >   If IsNull([MyTestField])
| >     DoCmd GoToRecord , , A_PREV
| >   End If
| > End Function
| >
| >                ... [e-mail]
|
| Two questions:
|
| If your database is designed such that the given table has
| certain fields
| that must always be filled anyway (checked for in a
| data-entry form), you
| could just use one of these fields, right?
|
| Also, what is A_PREV?
|
| Tony Hamilton
| [e-mail]
|
|

Yes , you could use any field in the table.

A_PREV is an intrinsic constant, see pg 239 of the Language Reference.  It
is documented as A_PREVIOUS.  I use a routine RecGoToPrev() that was in
one of the sample applications.

       ...    [e-mail]
=========================================================================
Date:         Fri, 9 Jul 1993 17:50:27 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re getting a report into a document and some answers

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
I have one question and a couple of comments/answers to recent questions.

1 Let us say I have a report which prints just fine. But What I want is
to get that report into an AMI or Word for Windows Document. The manual
talks about DDE and OLE for table data but not when it comes to
reports. Has anyone found/heard about an answer?



Re: record numbers
As someone said it is meaningless in a relational system to get hold
of / use the actual record number of a record in a table. But often does
make sense to be able to identify a representation of a record in the
output from a query.
So that one got
     1   gghfhgfh   kjlhkjhkjh
     2   jhi        jhoyoy
etc
On other systems I would use
   SELECT 1, x, y from T

and then use CSUM cumulative sum in the reporting tool. Not sure whether
this helps.

Re: The performance using sub reports comments.

It does not surprise me that there are problems with this, because
one needs quite a sophisticated optimiser to recognise that a
sub query (and thats really what the sub report is trying to represent)
need only be performed once. Maybe using a more sophisticated DBMS
that can do real sub queries as the back end might be the answer.
Even then it will depend on the DBMS. This is an example of
why those working with DBMS's request explain tools to
indicate which option an optimiser has chosen to use. That is when
there is an optimiser and there are different methods that can be chosen.
Even with some of the big database management systems one gets into
problems but it doesn't half help when there are optimisers.

Re: SQL2 ISO 9075, I think I have found an annonymous FTP site
from which the document can be obtained but I need to check that
this is allowed or whether the information that I have is
privileged due to my being on the BSI list.

Anne

Thankyou
===============================================================
=========================================================================
Date:         Fri, 9 Jul 1993 12:50:42 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Use of Macro set-value in Form
In-Reply-To:  Your message of Fri, 9 Jul 1993 11:55:54 +0800

Did you try changing the format of the date field to a date format?
Is the system date on your computer correct?
 I use the form preview mode frequently with access basic code, but have not
encountered your problem.  Good Luck-----Rich
=========================================================================
Date:         Fri, 9 Jul 1993 14:14:49 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      getting a report into a document / word processing

> Let us say I have a report which prints just fine. But What I want is
> to get that report into an AMI or Word for Windows Document. The manual
> talks about DDE and OLE for table data but not when it comes to
> reports. Has anyone found/heard about an answer?

I'll address four issues here to go "three sides 'round the barn" (as it
were):

[o] DDE -- there are a couple of (general) DDE examples on Compu$erve, but
I don't think DDE is the way you want to go ~ you aren't really exchanging
data but (rather) graphic images.

[o] OLE -- this is fine for those situations where you can ensure the
parties involved have the necessary software, but otherwise, that could
create a problem.

[o] Scanning -- Alan Simpson had an article recently in a magazine where he
advocated scanning a printed report to use as an online template where you
use the scanned image as the form template and "cut out" the field names
for input.

[o] Something better.  I realize it's not immediately available, but the
"Access 1.1 Developer's Guide" (SAMS/PHCP) addresses this situation.  It
should be on the shelf within the next couple of weeks.  The idea/approach
is (that) you should be able to use Access & word processing to document
your application -- a method is demonstrated for outputting reports into a
format which word processing can handle without using add-on products
(there are already a lot of add-ons for Access and more scheduled).


Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Sat, 10 Jul 1993 16:51:00 MST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Netware

Access Users:

I'd like to ask for opinions on the performance of Access
on Novell Netware. What do you think of its speed when
running through a network?

-Chris
=========================================================================
Date:         Sat, 10 Jul 1993 16:23:22 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Netware
In-Reply-To:  <[e-mail]>; from
              "[e-mail]" at Jul 10, 93 4:51 pm

> Access Users:
>
> I'd like to ask for opinions on the performance of Access
> on Novell Netware. What do you think of its speed when
> running through a network?
>
> -Chris

I run Access on Banyan, but I thought it might be of use to let anyone
know how that works. Basically, from testing, and from I have learned
by talking to both Microsoft and other sources, Access works just fine
over a network (Banyan Vines in my case) up the point of about 100,000
records, single-user. The following things can dramatically affect the
performance of Access, however:

1. Multiple users: even with a small table of 10,000 or so records, if
   you start getting 3-5 or more people accessing it, you are probably
   going to see some big performance hits.

2. Over 100,000 records, you are far better off with FoxPro if you still
   want a file/server implementation, or a true client/server setup would
   be great too.

3. Queries: complex relationships and queries will start slowing things
   down. My applications are usually around 3000-5000 records per table,
   and on a querie with maybe 6 such joined tables, Access still runs
   very fast, even over the network. I wouldn't push things much farther
   though.

The good news is that the limitations Access has with regards to performance
should all but disappear with the next major release, when Microsoft will
incorporate the FoxPro Rushmore technology into Access. It's a very powerful,
proprietary technology used to limit the amount of traffic needed over the
network when doing queries, and if you haven't used FoxPro v2.5 with large
databases on a network yet, you should - it's darn fast, even with large
queries and multiple users. Looking forward to that in Access...

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Sat, 10 Jul 1993 22:24:03 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Access on a network

I read Tony Hamilton's comments about using Access on a network.  I have a
few questions regarding this.  First, Tony, How did you hear that Microsoft
is going to incorporate Rushmore technology into Access?  Second, what does
access actually send over the network when a client logs on?--Does it send
tables, parts of tables or the whole database?  Third, Does anyone have
comments about the performance of Access on Windows for Workgroups, or when
using Shiva NetModem/E?  Any comments would be greatly appreciated.
--Rich Moldwin
=========================================================================
Date:         Sun, 11 Jul 1993 19:00:39 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access on a network
In-Reply-To:  <[e-mail]>; from "Richard Moldwin" at
              Jul 10, 93 10:24 pm

> I read Tony Hamilton's comments about using Access on a network.  I have a
> few questions regarding this.  First, Tony, How did you hear that Microsoft
> is going to incorporate Rushmore technology into Access?  Second, what does
> access actually send over the network when a client logs on?--Does it send
> tables, parts of tables or the whole database?  Third, Does anyone have
> comments about the performance of Access on Windows for Workgroups, or when
> using Shiva NetModem/E?  Any comments would be greatly appreciated.
> --Rich Moldwin

Can only comment on the first one. I was at DB/Expo in SF in May where
Bill Gates spoke about a number of things, and specifically he mentioned
this very issue. Not only will Access be incorporating Rushmore technology,
but the two products (Access and FoxPro) will ultimately merge (at least
on the Windows platform). There was some other more profound philosophizing
about the direction of database products from Microsoft, but that's another
story.

Anyway, I've also "heard" from a number of other places that the Rushmore
technology will definitely be in the next major release of Access, which
probably means Access 2.0. I can't recall where, but I'm sure someone
suggested that this might be as soon as the end of this year.

Access needs a lot of work, and I hope it all gets into 2.0. Specifically,
would like to see:

- Rushmore query technology
- Sophisticated data entry formatting (like with FoxPro), not just the
  simple, post-formatting that Access currently has.
- More events, like Visual Basic and Power Builder have.
- Ability to change all properties in real-time, not just when in design
  mode.
- Drag and drop event handling.
- SOmething like a Visual Basic timer control, that would allow you to
  write code which can be initiated outside of any user interactions with
  the application.
- Better documentation! (on-line and off)
- Built-in customizable toolbar (not the unsupported, flaky system of
  editing the system databases - yuk)

Hey, I love Access, and I know that it wasn't designed for hard-core
application development, but Microsoft made it so easy to work with (for
most simple stuff), and gave it so many capabilities, they may as well
go all the way...

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Mon, 12 Jul 1993 00:09:43 -0400
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thom Byxbe <[e-mail]>
Subject:      SUB

REG Thom Byxbe
SUB ACCESS-L
IND ACCESS-L
REV INDYMAIN
=========================================================================
Date:         Mon, 12 Jul 1993 16:29:31 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Use of Macro set-value in Form

Thanks to all the advisors.
(Specially Dmitry)

Finally, I know where my problem lies. I use '=' with Date(). I tried using
Date() instead and it works perfectly.

Chor Ling
=========================================================================
Date:         Mon, 12 Jul 1993 07:45:40 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Rickey Thomas Tom <[e-mail]>
Subject:      unsubscribe me

Please remove my subsciption to this newgroup.

Rick
=========================================================================
Date:         Mon, 12 Jul 1993 08:59:03 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Access Transaction Processing

I just discovered a problem with Access transactions over the weekend.
I'm using BeginTrans ... CommitTrans around a process that generates a
lot of records.  This is a single-user application, and a single-table
update, but I found that this improves performance considerably.

In the course of building the records, I execute a function that needs
to open another table, look for a matching record (Seek Method), and
place the corresponding value in the record being created.

Apparently you cannot open other tables within a transaction.  I've
searched the documentation for this and cannot find any references, so
I don't know if this is a BUG or a FEATURE.  Each record is written to
diskas if there were no BeginTrans, then it complains when it hits the
CommitTrans (as if there were no BeginTrans.  When I remove the call to
the function that opens the other table, everything works fine.

Has anyone else seen this behavior?  Is this a documented problem?

              ...    [e-mail]
=========================================================================
Date:         Mon, 12 Jul 1993 10:41:34 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Access - transaction procesing

 >
 > I just discovered a problem with Access transactions over the weekend.
 > I'm using BeginTrans ... CommitTrans around a process that generates a
 > lot of records.  This is a single-user application, and a single-table
 > update, but I found that this improves performance considerably.
 >
 > In the course of building the records, I execute a function that needs
 > to open another table, look for a matching record (Seek Method), and
 > place the corresponding value in the record being created.
 >
 > Apparently you cannot open other tables within a transaction.  I've
 > searched the documentation for this and cannot find any references, so
 > I don't know if this is a BUG or a FEATURE.  Each record is written to
 > diskas if there were no BeginTrans, then it complains when it hits the
 > CommitTrans (as if there were no BeginTrans.  When I remove the call to
 > the function that opens the other table, everything works fine.
 >

    Just a wild guess: this would only make sence if you let access know that
    what ever you do to the new table you open is not gonna be part of your
    transaction - i.e. if access is smart then if you asure it that you are
    openning the table "read  only" it might alow you to continue transaction.
    I am not sure if this is possible, but could be.
    What if you use some other way to search for the record?  Do a query or
    .findFirst on the dynaset...

    Dmitry
    [e-mail]
=========================================================================
Date:         Mon, 12 Jul 1993 12:00:41 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Crosstabulated reports problem...

Sending this to both the ACCESS-L list and comp.databases in hopes of
some help. I have a cross-tabulated query, where both the number and
content of the row and column headings varies both in content and number.
In other words, depending on the state of the underlying data, there may
be 3 column headings one time, or 20 another, and the original 3 may no
longer exist at one point, while new ones will.

Anyway, my problem is that when you cross-tabulate, the column-headings
are taken as the field names of the new dynaset based on that query. Well,
because field names and positions are hard-coded into forms and reports,
what I end up with is no way to design a single report or form which can
use this cross-tabulated query because of its variable nature.

This is not such a problem if you are a user of Access in design mode,
since you can use the report wizard to make a fairly quick report with
the proper fields based on the query AT ANY GIVEN TIME. But, I'm designing
an application here, where the users will not have access to design modes
or wizards.

I desparately need some help on this one.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Mon, 12 Jul 1993 14:46:57 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Access Transaction Processing
In-Reply-To:  <[e-mail]>; from
              "Jeff=[e-mail]" at Jul 12, 93 8:59 am

>
> I just discovered a problem with Access transactions over the weekend.
> I'm using BeginTrans ... CommitTrans around a process that generates a
> lot of records.  This is a single-user application, and a single-table
> update, but I found that this improves performance considerably.
>
> In the course of building the records, I execute a function that needs
> to open another table, look for a matching record (Seek Method), and
> place the corresponding value in the record being created.
>
> Apparently you cannot open other tables within a transaction.  I've
> searched the documentation for this and cannot find any references, so
> I don't know if this is a BUG or a FEATURE.  Each record is written to
> diskas if there were no BeginTrans, then it complains when it hits the
> CommitTrans (as if there were no BeginTrans.  When I remove the call to
> the function that opens the other table, everything works fine.
>
> Has anyone else seen this behavior?  Is this a documented problem?
>
>               ...    [e-mail]
>

Is your function using the same db?

I've run into problems where I don't use the same transaction db.

ie

In the options section:

Dim TranscactDB as database

and in each transaction function

set TransactDb = currentdb()

...if your function dim's another db...it's a problem.
=========================================================================
Date:         Tue, 13 Jul 1993 12:25:19 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Help on Functions

Can anyone tell me where to find documentation on CERTAIN functions
eg. IsZoomed , GetWindow etc ?

I think all these functions are Microsoft Access pre-defined functions.

Beats me why Microsoft Access did not document these functions in Microsoft
Access's Language Reference Book.

Chor Ling
[e-mail]
=========================================================================
Date:         Tue, 13 Jul 1993 01:28:17 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Help on Functions
In-Reply-To:  Your message of Tue, 13 Jul 1993 12:25:19 +0800

These are functions built into Windows, nd they are accessable to all windows
programs.  Any windows programming language should provide documentation in
the form of the Windows SDK Help file.  I think you may be able to download
this file for free from the microsoft bbs in the access directory. T
=========================================================================
Date:         Tue, 13 Jul 1993 01:31:07 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Help on Functions
In-Reply-To:  Your message of Tue, 13 Jul 1993 12:25:19 +0800

this is an addendum to the previous note:  The SDK help file is also included
in the Visual Basic Professional version.  I don't have the Microsoft BBS
number available, but if you call any Microsoft number, I'm sure they could
provide you with the BBS number.  There are also a number of very long and
complicated books on Windows programming that deal with these issues.  Good
Luck.---Rich Moldwin
=========================================================================
Date:         Tue, 13 Jul 1993 14:41:47 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Output Label to Ascii File

Does anyone knows whether Microsoft Access can output Report - Label to Ascii Fi
   le ?

I tried using Print - Print to File. However, the output file is not in Ascii
Format.

Chor Ling
[e-mail]
=========================================================================
Date:         Tue, 13 Jul 1993 07:09:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DAVID FARR <[e-mail]>
Subject:      Ascii Files

You need to use the Generic printer driver.  Also there are some other
changes you need to make to the report.  This was covered in one of the
Access magazines (first issue).  I don't have the information handy, but
could get if you need.  There is a file called 'output' on the
Microsoft BB (in access section) that is supposed to make ascii reports.
  Dave Farr
  [e-mail]
=========================================================================
Date:         Tue, 13 Jul 1993 14:19:52 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Locked by an. session on this machine???

Hi!

Up to now I couldn't solve the following problem:
Before I open a form I initialize a certain record of a table.
After making changes to this record that is part of a record-source of a
form I press "Print" in my form and then would like to do some additional
changes of this same record via an Access Basic function.

It used to work but now I always get the message "Couldn't update; Record
is locked by another session on this machine"

There IS no other session and no other user on this machine and I only can
assume that the record still is locked by the action that the form does by
itself.

Any hint appreciated!

Martin
=========================================================================
Date:         Tue, 13 Jul 1993 14:54:46 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Simon Mercer <[e-mail]>
Subject:      Re: Ascii Files

The magazine covering ascii output was 'Smart Access' (I can't remember the
publisher's name), there was an article in the first issue, and a database
using the techniques on the accompanying disk. As I remember, using the
generic printer driver may still give you some 'garbage' characters in the
output.
Simon Mercer
[e-mail]
=========================================================================
Date:         Tue, 13 Jul 1993 09:57:32 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Help on Functions

>
>Can anyone tell me where to find documentation on CERTAIN functions
>eg. IsZoomed , GetWindow etc ?
>
>I think all these functions are Microsoft Access pre-defined functions.
>
>Beats me why Microsoft Access did not document these functions in
Microsoft
>Access's Language Reference Book.

>Chor Ling

Are you certain?  Are you sure you aren't seeing the code used inside
another application and it's present in  either a module or in an add-on?


Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Tue, 13 Jul 1993 17:33:38 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Locked by an. session on this machine???
In-Reply-To:  Your message of Tue, 13 Jul 1993 14:19:52 CET

sometimes a pending transaction can cause this message.  I think that this
may include internal transactions used "behind the scenes" by the access
engine.  I have occasionally had success with this problem by including the
following statements in Access Basic code:
On error resume next
CommitTrans
On error goto 0

I have had similar problems where this approach hasn't worked, however.  Good
Luck
---Rich Moldwin
=========================================================================
Date:         Wed, 14 Jul 1993 12:44:29 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Organization: MU Dept of Veterinary Med. & Surg.
Subject:      Stop those pesky Update Query Messages

7/14/93   12:36 PM

I am developing an application that employs cascading Update Queries.
The problem is that Access keeps warning that rows or records are
going to be deleted or updated. I have turned off the Run By
Permission option but I can't stop the Update/Delete messages.
Does anyone have any suggestions (short of SYSTEM.mda alterations)
that would squelch these "Records will be deleted" message boxes?

Brian Glasgow
U of MO Vet School
Columbia MO
<[e-mail]>
=========================================================================
Date:         Wed, 14 Jul 1993 16:38:27 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      (how to) Stop those pesky Update Query Messages

>I am developing an application that employs cascading Update Queries.
>The problem is that Access keeps warning that rows or records are
>going to be deleted or updated. I have turned off the Run By
>Permission option but I can't stop the Update/Delete messages.
>Does anyone have any suggestions (short of SYSTEM.mda alterations)
>that would squelch these "Records will be deleted" message boxes?
>
>Brian Glasgow
>U of MO Vet School
>Columbia MO
><[e-mail]>

Eeeek!  Don't mod system.mda!  Try the <SetWarnings> macro action (or equivalent
 ABC) -- it works quite
nicely.  The text which accompanies it reads "Turns all system messages on or
 off.  Prevents pop-up
warnings from stopping the macro (although error messages always appear).  This
 has the same effect as
pressing Enter in each popup (typically an OK or Yes).

Turn it off before running the update query, then turn it back on after
 successful completion.

Hope this helps.

Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Wed, 14 Jul 1993 14:39:15 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Stop those pesky Update Query Messages
In-Reply-To:  <[e-mail]> from "Brian M. Glasgow" at Jul
              14, 93 12:44:29 pm

Brian,

Have you tried Set Warnings Off?

Good luck.

John
=========================================================================
Date:         Thu, 15 Jul 1993 08:28:11 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: Stop those pesky Update Query Messages

In the macro that runs the queries, put a sendkeys with enough ~ in
it to replace the CR you would normally have to press.  This supresses
the dialog boxes but I haven't yet discovered how to stop the beeps!!!

Cheers.   Graeme.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Wed, 14 Jul 1993 18:22:44 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Stop those pesky Update Query Messages
In-Reply-To:  Your message of Wed, 14 Jul 1993 12:44:29 CST

Dear Brian:
        Use either a macro or access basic code to turn "SetWarnings" to
false.  Access will then answer yes to every question and not show any
warning screens.  In Basic Code:
DoCmd SetWarnings FALSE
Your code here
DoCmd SetWarnings TRUE

I hope this works for you.  Good Luck
---Rich Moldwin
=========================================================================
Date:         Thu, 15 Jul 1993 09:26:15 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Delete table record

The selected item in the combo box that I deleted was still there after I have
deleted it.

main menu --> delete item form --> action ( delete item ) --> return to
main menu --> delete item form ( ERROR because deleted item STILL THERE !!!

2 Methods that I tried and failed
i) tAny As table .... tAny.Delete
ii) qDelete As QueryDef ... qDelete.Execute

However, when I viewed the table, the deleted item was not shown there.

I don't know much about Microsoft Access. In dbase, there is a command PACK
that will pack the table and record will not be shown.

Is there an equivalent command in Microsoft Access ?

Chor Ling
[e-mail]
=========================================================================
Date:         Wed, 14 Jul 1993 22:47:51 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Delete table record
In-Reply-To:  <[e-mail]> from
              "[e-mail]" at Jul 15, 93 09:26:15 am

>
> The selected item in the combo box that I deleted was still there after I have
> deleted it.
>
> main menu --> delete item form --> action ( delete item ) --> return to
> main menu --> delete item form ( ERROR because deleted item STILL THERE !!!
>
> 2 Methods that I tried and failed
> i) tAny As table .... tAny.Delete
> ii) qDelete As QueryDef ... qDelete.Execute
>
> However, when I viewed the table, the deleted item was not shown there.
>

        I am not sure I understand what you are doing, but if this is what I
        think it is try to requery the combo box after performing the deletion.
        If you are using a query or something like that for the source of the
        combo box then I think there was some picularity in the way access
        updates Dynasets. This may be totaly off key though...

        Good luck.
=========================================================================
Date:         Wed, 14 Jul 1993 22:54:10 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Have you noticed? (MS jokes...)

Have you noticed in the Appendix D or MS Access User's Guide the name of the
appendix on the first page of it (page 657) is: "Setting up MS Access on a
Network", but on the following page in it's header:
"Setting up Micro Soft Cirrus on a Network"!

If I am not mistaken 'Cirrus' is Yeudish (sp?) for trouble.  So that's why all
those sequrity problems!  Also the secret animation screen is accessed via some
trick with table called Cirrus, don't remember which trick exactely though.

[e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 06:01:59 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      DDE Access-->WinWord - comp.databases.ms-access #170

It seems that somewhere in the past somebody was asking about communications
between Access and MS-Winword. Or maybe, I just imagined that somebody needed
to communicate between the two. Anyway...

I found this information on comp.databases.ms-access. I have not tried the
WordBasic code so I can't endorse that it works.

The author of the WordBasic code can be reached at:
 (I changed the signature line @ to at to ensure the list manager doesn't get
  confused)
fekjsv at luecfou.ec.lu.se, his name is Johan Svensson.


hope this is useful ...



     (stuff deleted)
 > >Does anyone have experience with DDE between MSAccess and WinWord ?
     (stuff deleted)
 >
 > As the manuals are VERY sparse in giving us information on how
 > to use DDE with Access, I give the group a "head-start" sample
 > of how to use Winword-DDE-Access. It should work with Excel as
 > well:
 >
 > Sample DDE-macro:
 >
 -------------------------------------------------------------------------------
 -----
 > Declare Function isapploaded Lib "kernel"(name$) As Integer Alias
 "getmodulehandle"
 > dbName$ = "FOO"              'Your Access-base goes here
 >
 > 'Main:
 >      If isapploaded("MSAccess") Then
 >              sysCh =  DDEInitiate("MSAccess", "System")
 >              topics$ = DDERequest$(sysCh, "Topics")
 >              If InStr(topics$, dbName$) = 0 Then notloaded = 1
 >      Else
 >              notloaded = 1
 >      End If
 >      If notloaded = 1 Then
 >              a = MsgBox("Database " + dbName$ + " is not loaded, do You want to?", 36)
 >              If a = - 1 Then
 >                      Shell dbName$ + ".MDB"
 >              Else
 >                      Goto by
 >              End If
 >      End If
 >
 >
 >      pfStr$ = q$ + "PF*" + q$                'filter PF-records
 >      fraktCh =  DDEInitiate("MSAccess", dbName$ + ";SQL Select count([KOD]) ffom
 PORTO where
 >              [KOD]  not like " + pfStr$ + ";")
 >      number$ = DDERequest$(fraktCh, "data")  'count # of recs
 >      number = Val(number$)                   'convert to numerical
 >      If number > 0 Then
 >              fraktCh =  DDEInitiate("MSAccess", dbName$ + ";SQL Select [KOD], [NAMN],
 [PRIS],
 >                      [MOMSPL] from PORTO where [KOD] not like " + pfStr$ + ";")
 >              sqlresult$ = DDERequest$(fraktCh, "data")
 >      Else
 >              MsgBox "Couldn't find data."
 >              Goto bye
 >      End If
 >
 >      Dim results$(number)
 >      nextRec = 1
 >      For i = 0 To number - 1
 >              curRec = InStr(nextRec, sqlresult$, p$) set curRec to pos for next rec
 >              Print "Retrieving data: " + Str$(i + 1) + " of  " + number$
 >              tab = InStr(nextRec, sqlresult$, t$)    'set tab to pos for first TAB (field)
 >              tab2 = InStr(tab + 1, sqlresult$, t$)   'set tab to pos for second TAB
 (field)
 >              tab3 = InStr(tab2 + 1, sqlresult$, t$)  'set tab to pos for third TAB
 (field)
 >
 >              REM The following is ugly, but neccessary - damn You, WordBasic...
 >              results$(i) =   Mid$(sqlresult$, nextRec, tab - nextRec) + " \ " +
 >                      Mid$(sqlresult$, tab + 1, tab2 - tab - 1) + " \ "
 >              results$(i) = results$(i) +
 >                      Mid$(sqlresult$, tab2 + 1, tab3 - tab2 - 1) + " \ " +
 >              Mid$(sqlresult$, tab3 + 1, curRec - tab3 - 1)
 >              nextRec = curRec + 2                    'jump to next rec
 >      Next    'end of for-loop
 >
 > DDETerminateAll              'kill all conversations before returning
 >
 >
 -------------------------------------------------------------------------------
 -------
 >
 >
 > I think some of You, who happened to read the manuals shouted "what!"
 > or something like that, but it works (fine)! Just read about WordBasic's
 > limitations regarding size of string-variables and such - it's really
 > annoying. Often, You have to split SQL-queries into a couple of queries
 > not to break the 32k stringsize-barrier. All strings in a macro mustn't
 > exceed 64k, so You have to reuse and REDIM strings.
 >    Hope this shed a little light on DDE-programming and if You absolutely
 > didn't follow the sample - please drop me a line and I'll try to explain
 > a little more.
 >
 >
 > Regards,
 >
 > Johan Svensson,
 > JoS-Ware Comp Tech, Sweden




-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 09:30:51 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Have you noticed? (MS jokes...)
In-Reply-To:  Message of Wed,
              14 Jul 1993 22:54:10 -0700 from <[e-mail] ELEY.EDU>

"Cirrus" was the original "code-name" for Access when it was being developed.
I remember reading an article in one of the magazines (Byte or PC Magazine)
that referred to Microsoft's Windows relational database-in-development,
Cirrus.  I have a suspicion that they originally intended to market it
under that name and had the manual written already when they decided on
the name Access.  Some poor proofreader missed fixing a header....:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 15 Jul 1993 08:28:41 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Sub-form datasheets

Hello.

I have a subform, linked via child and master properties, to the form
upon which it resides. The subform is a datasheet, and basically displays
a couple of fields from the many side of the one-to-many relationship.

Question: what is the best way to allow the user to _select_ one of
the records in the subform datasheet, at which point I would then open
up an entirely new form with all 30 fields or whatever for that record in
a nice form view (possibly showing a new one-to-many relationship as
well: the database structure is rather vertical with no less than 6 or 7
one-to-many relationships in sequence.)

The easiest solution, although I am looking for something even easier,
that I am aware of, is to change from a datasheet to a continuous form
that _looks_ like a datasheet, and just insert a button, which would then
be displayed for every record in the subform. That button could then be
used to jump to the other form. Instead, what I'd prefer to do, would
be to let the user double-click on a row in the datasheet or something,
and do it that way. But, I'm not aware of how to do something like that,
(or anything similar) within Access.

Any ideas?

(btw: I have asked a few questions as of late to this list, and I just
wanted everyone to know that I am receiving all of your helpful suggestions.
I cannot reply since I get so many of them! So, thank you very much for
the help you have provided. This list is one of the most productive and
useful I have seen.)

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 15 Jul 1993 10:38:00 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Organization: MU Dept of Veterinary Med. & Surg.
Subject:      Pesky Update Query Warnings Solved

Thanks to Rich, Phil and John for the SetWarning Macro Action Tip.
The problem with the Update query message boxes is solved. Those MS
people have a command for everything, if only I could remember them
all....
=========================================================================
Date:         Thu, 15 Jul 1993 08:57:54 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Stop those pesky Update Query Messages

[e-mail] Wrote:
|
|
| 7/14/93   12:36 PM
|
| I am developing an application that employs cascading Update
| Queries.
| The problem is that Access keeps warning that rows or records
| are
| going to be deleted or updated. I have turned off the Run By
| Permission option but I can't stop the Update/Delete messages.
| Does anyone have any suggestions (short of SYSTEM.mda
| alterations)
| that would squelch these "Records will be deleted" message
| boxes?
|
| Brian Glasgow
| U of MO Vet School
| Columbia MO
| <[e-mail]>
|
|

This is how I get around that problem:

  DoCmd SetWarnings False
  DoCmd Echo False
  DoCmd RunSQL "DELETE * FROM [Monday Dates] WITH OWNERACCESS OPTION;"
  DoCmd SetWarnings True
  DoCmd Echo True


        ...    [e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 09:22:40 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Sub-form datasheets

[e-mail] Wrote:
|
|
| Hello.
|
| I have a subform, linked via child and master properties,
| to the form
| upon which it resides. The subform is a datasheet, and
| basically displays
| a couple of fields from the many side of the one-to-many
| relationship.
|
| Question: what is the best way to allow the user to
| _select_ one of
| the records in the subform datasheet, at which point I
| would then open
| up an entirely new form with all 30 fields or whatever for
| that record in
| a nice form view (possibly showing a new one-to-many
| relationship as
| well: the database structure is rather vertical with no
| less than 6 or 7
| one-to-many relationships in sequence.)
|
| The easiest solution, although I am looking for something
| even easier,
| that I am aware of, is to change from a datasheet to a
| continuous form
| that _looks_ like a datasheet, and just insert a button,
| which would then
| be displayed for every record in the subform. That button
| could then be
| used to jump to the other form. Instead, what I'd prefer
| to do, would
| be to let the user double-click on a row in the datasheet
| or something,
| and do it that way. But, I'm not aware of how to do
| something like that,
| (or anything similar) within Access.
|
| Any ideas?
|
| (btw: I have asked a few questions as of late to this
| list, and I just
| wanted everyone to know that I am receiving all of your
| helpful suggestions.
| I cannot reply since I get so many of them! So, thank you
| very much for
| the help you have provided. This list is one of the most
| productive and
| useful I have seen.)
|
| --
| Tony Hamilton                 |
| -Intel Corporation            | voice: 916-356-3070
| --Folsom Engineering Services | mailstop: FM2-55
| ---Engineering Resource Group | email:
| [e-mail]
| ----Software Technician       |
|
|

Tony -

   I have use a button in the footer of the parent form that opens up
the child form and positions it to the record that was current in the
parent form.  Here's the routine that the button is attached to:

Function GoFormSync (SVKey As Variant, Key As Control, KeyNM As String,
FormName As String)

  On Error GoTo GoFormSyncErr
  SVKey = Key

  'MsgBox Str(IDKey), 0
  DoCmd OpenForm FormName
  DoCmd Requery      'In case records have been added.
  rtn% = RecFindFirst(KeyNM & " = " & SVKey, False, True, False)
  GoFormSync = True
  Exit Function

GoFormSyncErr:
  MsgBox Error$, 0, idsAPPNAME
  GoFormSync = False
  Exit Function

End Function
=========================================================================
Date:         Thu, 15 Jul 1993 11:13:00 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Sub-form datasheets
In-Reply-To:  <[e-mail]>; from
              "Jeff=[e-mail]" at Jul 15, 93 9:22 am

Not sure you understand. I already do what you have described, in various
areas. I have a partent form, with a child form _already open_, and I
need the user to be able to select one of the records on the _child form_,
which then opens up another form. The child form is, of course, a subform,
actually attached to the parent form. That subform is a datasheet.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 15 Jul 1993 11:15:50 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Linda D. Cornell" <[e-mail]>
Subject:      How to go about learning Access

Hi there,

I'm curious.  How have all your folks out there gone about learning Access?
I'm trying to use Access to prototype a fairly complex database that will
be networked.  Cue cards are cute, and they were really helpful getting
started along with the manuals, but.....

Actually, this group has been extremely helpful - especially just browsing
the messages that get posted.  They give me a feeling for what can and
cannot be done, and what some of the work-arounds might be.

In my current situation, what I think I need is a tutor/consultant.
Anyone know anyone available in the Seattle area?  But....what other
training opportunities are out there?!?!?

Thanks in advance for any pointers!!

Linda Cornell
[e-mail]
University of Washington
Office of Research
=========================================================================
Date:         Thu, 15 Jul 1993 14:04:59 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Followup:  Stop those pesky Update Query Messages

> This is how I get around that problem:
>
>   DoCmd SetWarnings False
>   DoCmd Echo False
>   DoCmd RunSQL "DELETE * FROM [Monday Dates] WITH OWNERACCESS OPTION;"
>   DoCmd SetWarnings True
>   DoCmd Echo True
>       ...    [e-mail]


Perhaps this is just the systems programmer in me coming out, but I'm curious
 about the
technique(s) involved here (i.e. patternwise).  The structure of the commands
 seems to
be:

A
B
C
A
B

whereas for the sake of consistency and structure, I would have expected to see
 it as

A
B
C
B
A

(merely undoing each step as you go)

I realize they [probably] work the same, but it's just a matter of curiousity...
=========================================================================
Date:         Thu, 15 Jul 1993 11:36:14 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "j.r." <[e-mail]>
Subject:      Re: Have you noticed? (MS jokes...)
In-Reply-To:  Message of Thu, 15 Jul 1993 09:30:51 EST from <NBRINDLE@INDYCMS>

Nathan Brindle--I love your disclaimer and would like to share it with those
on the list:
   Disclaimer:  My opinions are my own.  [Univ/Co/Org] can speak for itself.

   Bravo to those who are willing to help with MS Access problems and find
   solutions for undocumented nuances in the program.

J.R. Fischer-Schnieder    Arizona State University
   Department of Communications

J.R. Fischer-Schnieder (AUJRF)
Department of Communication - Arizona State University - Tempe, AZ 85287
University Phone:  TBA  Off campus phone: [phone]  Pager: 420-2254
=========================================================================
Date:         Thu, 15 Jul 1993 11:57:48 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: How to go about learning Access

>
> I'm curious.  How have all your folks out there gone about learning Access?
> I'm trying to use Access to prototype a fairly complex database that will
> be networked.  Cue cards are cute, and they were really helpful getting
> started along with the manuals, but.....
>
> Actually, this group has been extremely helpful - especially just browsing
> the messages that get posted.  They give me a feeling for what can and
> cannot be done, and what some of the work-arounds might be.
>
> In my current situation, what I think I need is a tutor/consultant.
> Anyone know anyone available in the Seattle area?  But....what other
> training opportunities are out there?!?!?
>
> Thanks in advance for any pointers!!
>

Linda,

There are several books available that provide some guidence to Access.
One of those books, _Access, Step by Step_ published by MS Press provides a
tutorial, complete with machine examples. I mention it because I have used it.
As I said earlier there are others.

As far as consultants, I would offer my services but I can't commute from
Sunnyvale, CA to Washington easily.(:-)) There must be some consultants in your
immediate area that can help.

There is a newsgroup that deals with Access - comp.databases.ms-access. That
group provides different information than is available on this list. There may
also be intersections between the two.

One last source for training, Microsoft University. If they don't have a course
on Access they soon will. They have an 800 number (can't remember it).

g.mo


-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 11:57:52 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Followup: Stop those pesky Update Query Messages

[e-mail] Wrote:
|
|
| > This is how I get around that problem:
| >
| >   DoCmd SetWarnings False
| >   DoCmd Echo False
| >   DoCmd RunSQL "DELETE * FROM [Monday Dates] WITH
| OWNERACCESS OPTION;"
| >   DoCmd SetWarnings True
| >   DoCmd Echo True
| >       ...    [e-mail]
|
|
| Perhaps this is just the systems programmer in me coming out,
| but I'm curious
|  about the
| technique(s) involved here (i.e. patternwise).  The structure
| of the commands
|  seems to
| be:
|
| A
| B
| C
| A
| B
|
| whereas for the sake of consistency and structure, I would
| have expected to see
|  it as
|
| A
| B
| C
| B
| A
|
| (merely undoing each step as you go)
|
| I realize they [probably] work the same, but it's just a
| matter of curiousity...
|
|

  Yes, that should work and looks better.  Thanks,

     ... [e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 11:53:07 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Sub-form datasheets

[e-mail] Wrote:
|
|
| Not sure you understand. I already do what you have
| described, in various
| areas. I have a partent form, with a child form _already
| open_, and I
| need the user to be able to select one of the records on the
| _child form_,
| which then opens up another form. The child form is, of
| course, a subform,
| actually attached to the parent form. That subform is a
| datasheet.
| --
| Tony Hamilton                 |
| -Intel Corporation            | voice: 916-356-3070
| --Folsom Engineering Services | mailstop: FM2-55
| ---Engineering Resource Group | email:
| [e-mail]
| ----Software Technician       |
|
|

Tony -

  What I suggested will work if the focus is in the current child record
(on the parent form) and the users presses the "Child" button on the
parent form's footer.
  It sounds like you want the user to be able to just select the child
record by clicking on it.  Is this a read-only form?
  Other than some form of multi-column combo box, I can't see how you'd do
this in Access.  If you find out, let me know.

   ... [e-mail]
=========================================================================
Date:         Thu, 15 Jul 1993 12:34:56 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ken Howard <[e-mail]>
Subject:      Update Query like Cross-Tab's?

Cross-tab queries are almost what I need. Except,

I'd like to display in the matrix, a data value from the join rather
than a summarization. And then of course, be able to update it.

E.g.

Client Table:           Rooms Table:
  Client ID               Room ID
  ...                     Room Number
                          Client ID
                          Status (Reserved, Confirmed, Occupied)

Cross-Tab Query:

              Room1     Room2   Room3   Room4

Client1         R
Client2                   C
Client3                          O
Client4                                  O

This would give me dense information presentation, and let me update existing
records in the Rooms Table. If I could find a way to do it ... .

Any thoughts, other attacks on the problem? (Dealing here with sufficient
data, that I need horizontal and vertical scroll to see all entries).

Thanks much,
Ken

---------------------------------------------------------------------
Ken Howard                                        [e-mail]
Network Services, Computing Services              Tel  [phone]
University of Victoria                            Fax  [phone]
--
=========================================================================
Date:         Thu, 15 Jul 1993 12:47:02 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Sub-form datasheets
In-Reply-To:  <[e-mail]>; from
              "Jeff=[e-mail]" at Jul 15,
              93 11:53 am

I am sorry. Perhaps you are right and it will work. I must apologize,
then, and ask for the code back. I have a nasty habit of deleting
anything that doesn't seem readily useful. I just assumed, based on
your explanation paragraph, that it didn't apply. I think this is what
you mean now:

_______________________________________________
|                                             |
|                                             | <--Parent Form
|                                             |
|                                             |
| _________________________________           |
| |_______________________________|           |
| |_______________________________| <------------Child(sub)form
| |_______________________________|           |
|                                             |
|---------------------------------------------|
| [____]                                      | <--ParentFooter
_______________________________________________
    ^
    |
 Button


And you propose, that as long as the focus is in the right record
in the child form, there is a way to use the button in the footer to
take that record and use it to open up the new form at the right location.

See, I thought this wasn't possible because I figured once you hit the
button, the focus leaves the child form immediately. Are you saying that
because it is in the footer, there can be two foci? I'm sure I would know
exactly what you are saying if I still had the code you gave me (kicking
myself here for being so pig-headed).

If this is what you propose, to use that button to bring up another form
at the record pointed to in the child/sub-form, then this is indeed what
I am looking for. Let me know...
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 15 Jul 1993 15:45:49 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Sub-form datasheets / Events

> Not sure you understand. I already do what you have described, in various
> areas. I have a partent form, with a child form _already open_, and I
> need the user to be able to select one of the records on the _child form_,
> which then opens up another form. The child form is, of course, a subform,
> actually attached to the parent form. That subform is a datasheet.

To make it simple (*) then:  you are wanting to trap/detect events in a
 datasheet form.  I don't think this can
be done.  The datasheet (table, query, form, report) appear to be the most
 inflexible (outside of the
language specs) of the Access objects.  As you've probably discovered, you can't
 dynamically alter most of
the characteristics of the objects, let alone the datasheet, including the
 headers as they appear on the
screen (unless you cheat ahead of time).

Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana, USA
=========================================================================
Date:         Thu, 15 Jul 1993 16:52:56 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Have you noticed? (MS jokes...)
In-Reply-To:  Message of Thu, 15 Jul 1993 11:36:14 -0700 from <AUJRF@ASUACAD>

On Thu, 15 Jul 1993 11:36:14 -0700 j.r. said:
>Nathan Brindle--I love your disclaimer and would like to share it with those
>on the list:
>   Disclaimer:  My opinions are my own.  [Univ/Co/Org] can speak for itself.
>

*grin* I have to admit that it is not original...either I got the idea from
someone else on this list or on the listowner's list...it goes along with
the motto, "What we do is our business."

Now, back to your regularly-scheduled listserv...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 15 Jul 1993 17:27:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Sub-form datasheets
In-Reply-To:  Message of Thu,
              15 Jul 1993 12:47:02 PDT from <[e-mail] EL.COM>

This is probably a good time to mention that logs of ACCESS-L are kept
by the listserver.  (I think that was in the FAQ but the system here is
being strange and I want to get this out before I lose the connection
again.  If you need a log, you send the command

GET ACCESS-L LOGYYMM

(where YYMM is the year and month, i.e., 9307) to LISTSERV@INDYCMS.

There is a package available called LDBASE which gives you a realtime
interface with LISTSERV to do subject or keyword searches on the list
archives.  You may want to review the LISTSERV doc called LISTDB MEMO
if you are interested in this.  Send the command INFO DATABASE to
LISTSERV@INDYCMS to get this file sent to you.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 15 Jul 1993 17:25:17 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Have you noticed? (MS jokes...)
In-Reply-To:  Your message of Wed, 14 Jul 1993 22:54:10 -0700

Dear Dimitry:
        I think that the Yiddish word that you are looking for is Tzuras.
Perhaps it is related to the Hebrew word for "leprosy", Tzorat, the penalty
for speaking ill of someone in the Old Testament.  This may help to further
explain the problems we've been having with Access :-)
=========================================================================
Date:         Thu, 15 Jul 1993 17:47:03 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Sub-form datasheets
In-Reply-To:  Your message of Thu, 15 Jul 1993 11:53:07 PDT

I think we a starting to better define the problem.  Imagine a subform in the
details section of a parent form.  For best results do not link the parent
form to the subform.  The subform can be in either continuous form or
datasheet mode (it makes no difference).  The fields in the subform are text
boxes or combo boxes.  The text or comboboxes are linked to fields in a table
or query.  The user wants to click on one of the many displayed subform
record, and thereby view either a new record (from another table or query) of
the full record corresponding to the abbreviated record that he just clicked
on.  To implement this whenever the user clicks od dblclicks on a record
field, just run a macro or code from the On Enter or On DoubleClick property
of the field.  The macro or code can then then display any other record (or
the complete version of the selected record) in the form header/footer, or on
a newly loaded form.  Is this what you are looking for?
---Rich
=========================================================================
Date:         Thu, 15 Jul 1993 17:51:16 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Sub-form datasheets / Events
In-Reply-To:  Your message of Thu, 15 Jul 1993 15:45:49 EDT

When using the datasheet view of a form, the datasheet fields trap events
just as you are looking at the form view.  The same code or macro will run
regardless of the view.  I use this approach frequently!
=========================================================================
Date:         Thu, 15 Jul 1993 17:25:10 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re: How to go about learning Access

Sorry about the previous "non-message" forward of this... learning a new
editor...

>I'm curious.  How have all your folks out there gone about learning Access?
>I'm trying to use Access to prototype a fairly complex database that will
>be networked.  Cue cards are cute, and they were really helpful getting
>started along with the manuals, but.....

>Actually, this group has been extremely helpful - especially just browsing
>the messages that get posted.  They give me a feeling for what can and
>cannot be done, and what some of the work-arounds might be.

>In my current situation, what I think I need is a tutor/consultant.
>Anyone know anyone available in the Seattle area?  But....what other
>training opportunities are out there?!?!?

>Thanks in advance for any pointers!!

>Linda Cornell
>[e-mail]
>University of Washington
>Office of Research

Well, I'm slogging through the manuals, while collecting tidbits from
the list and subscribing to a couple of magazines.  The suggestion
about books is good; you may find them easier than the manuals, and some
go farther into problem-solving and creative applications.  It sounds
like you are looking for comprehensive training, rather than help with
specific problems, so Microsoft U. is a good (albeit probably expensive)
suggestion; I'd bet they have a bunch of courses already.  Community
colleges may offer introductory courses, such as some have done for
Windows, Excel, etc.

I'm aware of two user groups in our area dealing with Access.  These
may be helpful to you, and you could certainly find your tutor/
consultant there.  I'll send details to you directly.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Fri, 16 Jul 1993 11:27:02 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Import in Visual Basic 3.0-app

Hi to all!

I know that all connected lists are Access-lists but maybe some of you are
experimenting with VB3.0 too.

What I'd like to do is to import ASCII and Excel-data in my VB3.0-managed
Access Database. I don't want to switch to Access for this purpose.

Maybe one of you (any guy at MS listening today???) can mail a hint??

Thanks in advance!

Martin
=========================================================================
Date:         Fri, 16 Jul 1993 06:22:37 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: How to go about learning Access

>
> Sorry about the previous "non-message" forward of this... learning a new
> editor...
>
> >I'm curious.  How have all your folks out there gone about learning Access?
> >I'm trying to use Access to prototype a fairly complex database that will
> >be networked.  Cue cards are cute, and they were really helpful getting
> >started along with the manuals, but.....
>
... (stuff deleted)
... so Microsoft U. is a good (albeit probably expensive)
> suggestion; I'd bet they have a bunch of courses already.
... (more deletions)
>

I just received a MS University catalog in the mail. There are two courses
covering Access. The first course is an Introduction. The course outline:

        Introduction
                Menu Options
                Table Design
                Importing/exporting tables
                Attaching tables
        Queries
                Select queries
                Criteria for selection
                Calculated fields
                Sorting
                Fields used for selection only (show flag)
                Multiple queries
                Parameter queries
                Action queries
                Using the Report Wizard
                Modifying reports with the design tools
                Grouping/Sorting
                Subtotaling
                Mailing labels
        Form Basics
                Using the Form Wizard
                Modifying forms with the design tool
                Form sections
                Control Types
                Control/form properties
                Modifying the appearance of forms

The second course is _Advanced Programming Using Microsoft Access_. The outline:

        Advanced forms
                Multipage forms
                Subforms
                Field lists (list boxes)
                Pop-up lists (combo boxes)
                Option groups
                Command buttons
        Macros
                Actions
                Conditional execution of actions
                Macro groups
                Autoexec macro
                Autokeys macro
        Modules (Access Basic)
                Intorduction
                Decision and looping structures
                Variables
                Scooping (sic) and lifetime
                Explicit/implicit declaration
                Object variables
                Control variables
                Report/form variables
                Database variables
                Recordset variables
                Manipulating data
                Array
                Multiuser concepts
                Using transactions to ensure data integrity

There is promise of a Microsoft Access Video Trainig system. The course is
still under development so I won't include the course outline. It appears the
courses (there are three) in the video series will cover much of the material
listed above.

The course length, prerequisites and cost:
                Introduction -  3 days, familiarity with Windows, $1125/person
                Advanced - 2 days, completion of Introduction, $750/person
                Video series, none, $999 + s&h + sales tax

I can't afford this kind of education but I offer the information for those
who are interested and/or can afford the courses.

g.mo




-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Fri, 16 Jul 1993 10:11:30 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Gordon Charrick <[e-mail]>
Subject:      Re: How to go about learning Access

Unfortunately, I don't remember the title of the book or the publisher
(what can I say? :-)) but I saw a book at CompUSA a couple weeks ago that
really looked good. They used the book to develop a complete application
for a vet service. The book had a 3.5" disk in the back. As a matter or
fact, I tried to get it last night but they were out. Does anyone know
the book I'm talking about?
=========================================================================
Date:         Fri, 16 Jul 1993 09:19:48 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Passing Variable Names to Access Basic

  I'd like to be able to pass the name of a global variable to an Access
Basic function and then be able to place a value in that variable; e.g.

Global SaveCurrentPartNo As String
SetGlobal("SaveCurrentPartNo", [PartNo])  Where:

Function SetGlobal(MyVar As String, VarValue As String)
  (Contents of MyVar) = VarValue
End Function

  I am able to do this kind of thing with data elements, but not with
global variables; e.g.

SetField("PartNO", "Part Master", [PartNo])  Where:

Function (FieldNM As String, TableNM As String, FieldVal As String)
Dim DB As Database
Dim TBL As Table

Set DB = CurrentDB()
Set TBL = DB.Opentable(TableNM)

TBL(FieldNM) = FieldVal

TBL.Close
End Function

  Any ideas ??????


       [e-mail]
=========================================================================
Date:         Fri, 16 Jul 1993 10:36:12 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon Goldstein <[e-mail]>
Subject:      Re: How to go about learning Access
In-Reply-To:  "[e-mail]:gov:Xerox's message of 16-July-93 (Friday)
              10:11:30 EDT"

Re:  >>I saw a book at CompUSA a couple weeks ago that
really looked good. They used the book to develop a complete application
for a vet service. The book had a 3.5" disk in the back. As a matter or
fact, I tried to get it last night but they were out. Does anyone know
the book I'm talking about?<<

The book is The Microsoft Access Bible.  I do not remember the publisher.
There are two authors - I'm not good at remembering names.  I purchased the
book for $32.00 (U.S.A.)at CompUSA with the discount.

I own the book and it is quite good.  The text is very readable.  A good
presentation of object-oriented/event driven/relational DB application
development ala MS Access is provided through the development of the
veterinarian application mentioned.

About the only section of the book that might be considered lacking is the
presentation of Access Basic.  The book does give the fundamentals, including
an appendix with the most frequently used functions, but it is not intended as
an introduction to programming.  The emphasis is on the development of
applications without the use of traditional programming techniques.  But, as
the book points out, there are those times ...

A recent note regarding use of Modules instead of Macros for the development of
applications that will be generated under the developers version suggests that
for some the brief overview of functions might not be enough.  But Access Basic
should not be too difficult to pick up for anyone with a programming
background, however.  The functions are documented fairly completely within
Access.

Good luck,
Jon
=========================================================================
Date:         Fri, 16 Jul 1993 15:28:22 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Create second level menus in custom menus

Is it possible to create a second level menu in a custom toolbar menu for a
form? If so, how might I go about doing this?
=========================================================================
Date:         Fri, 16 Jul 1993 20:48:18 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>
Subject:      VB 3.0 and ODBC

After finally getting a peek at the VB3.0 doc and how it interfaces
with ODBC, my jaw kinda dropped down to my knees.  Did I miss something,
or is the only way to create a result set that a VB control understands
is via a SQL SELECT?

My problem here is with providing SQLProcedures that return a result set
(and can be SQLFetch-ed) after a {call XYZ}.  Procedures NO NOT appear to
be supported in VB3.0.  Even to get at other ODBC SQLxxx API stuff appears
to be pretty lame (running a VB app to get column info instead of externalize
the ODBC SQLColumns call).  If I'm missing something, please correct me before
I set fire to the VB3.0 disks (which most interestingly were packaged with
the odd disks in one wrap and the even disks in the other).

GR.

--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail]            (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)
=========================================================================
Date:         Sat, 17 Jul 1993 09:25:31 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Delete table record

Thanks Dmitry ! :-)
Actually, my friend told me exactly the same thing. However, I made a mistake
of assuming Microsoft Access will automatically requery all items in the form
when I executed the macro command openform to open form.

Thank God I took your advice. All the deleted items are gone.

Chor Ling
=========================================================================
Date:         Sun, 18 Jul 1993 13:22:22 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Sub-form datasheets / Events
In-Reply-To:  <[e-mail]>; from "Richard Moldwin" at
              Jul 15, 93 5:51 pm

> When using the datasheet view of a form, the datasheet fields trap events
> just as you are looking at the form view.  The same code or macro will run
> regardless of the view.  I use this approach frequently!

This did the trick! I don't know why, but this didn't work for me before,
but I must have been doing something wrong. Ever since, I assumed the
events didn't work from a datasheet view. Thanks to everyone who responded
on this problem.


--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Sun, 18 Jul 1993 15:56:01 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Roger Lurie <[e-mail]>
Subject:      Microsoft Access for the Mac?

Does anyone know if Microsoft plans to develop a copy of Access for the
Macintosh?

-------------------------------------------------------------------------
Roger Lurie
Arizona State University, Administrative Information Technology
Tempe, Arizona  85287-0101
Telephone: [phone]             Fax:    [phone]
Internet:  [e-mail]  Bitnet: icsral@asuacad
-------------------------------------------------------------------------
=========================================================================
Date:         Sun, 18 Jul 1993 17:40:54 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Passing Variable Names to Access Basic
In-Reply-To:  <[e-mail]> from
              "Jeff=[e-mail]" at Jul 16,
              93 09:19:48 am

>
>   I'd like to be able to pass the name of a global variable to an Access
> Basic function and then be able to place a value in that variable; e.g.
>
> Global SaveCurrentPartNo As String
> SetGlobal("SaveCurrentPartNo", [PartNo])  Where:
>
> Function SetGlobal(MyVar As String, VarValue As String)
>   (Contents of MyVar) = VarValue
> End Function
>
        If I understand you correctely you are trying to pass variables by
        reference rather then by value.  If that is correct I have a surprize
        for you -- that is the default way Basic passes variables!
        To pass a var by value you need to tell basic to do so.  In Quick Basic
        this is done with BYVAL keyword:

        Function MyFunc (BYVAL x As Integer)

        Then inside you can change x and have it stay the same in the calling
        invironment.

        However in a default declaration:  Function MyFunc (x As Integer)
        if you change the value of x inside your function it will also change in
        the calling invironment.

        ------------
        But you weren't asking for this were you ... :)

        Ok.  I think you can do what you want to do with just a straignt
        assignment:

        SavePreviousPartNo = [PartNo]

        Since this var you declare as global you should be able to do this in
        any piece of code in the same module.  I think you can do the same
        accross modules.  But if not try looking for help on "COMMON" stamtent.

        Good luck.
        If I am totally off key -- let me know, may be we can figure out a
        better solution.

        Dmitry
        [e-mail]
=========================================================================
Date:         Mon, 19 Jul 1993 01:28:02 -0700
Reply-To:     Kristina Sontag <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kristina Sontag <[e-mail]>
Subject:      Re: How to go about learning Access

I learned Access the old-fashioned way, I read LOTS of books and
periodicals.  I started with the manuals and then picked up _Understanding
Microsoft Access_ by Alan Simpson (pub: Sybex, ISBN: 0-7821-1168-8) which
goes a bit more in depth about several important subjects like queries and
macros.  Also, since I had not had any experience with SQL before (yes, my
first bout with databases was Access!) I picked up _The SQL Standard_ by
C.J. Date with Hugh Darwen (pub: Addison-Wesley, ISBN: 0-201-55822-X).  I
also subscribed to _Inside Microsoft Access_ published by the Cobb Group
and _Smart Access_ published by Pinnacle.  I believe both of these
periodicals have been mentioned before in this list.  I of course have
been watching this list as well as the comp.databases.ms-access newsgroup
for any tidbits that might come up.  Last, but by no means least I have
called the MS-Access support line many times if I encountered a problem
that was not addressed anywhere that I had seen.  They are very helpful,
though sometimes they have been as puzzled as I.  All in all, I have been
picking up bits of information on Access here and there, but there are
still many unanswered questions for me too.

Hope this helps in your search for information!

--kris
[e-mail]
=========================================================================
Date:         Mon, 19 Jul 1993 08:27:16 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         FARLEY <[e-mail]>
Subject:      Touch-sensitive screens w/ACCESS

Hello.

Have any of you out there had any experience with touch-sensitive
screens w/ACCESS?

TIA,
Laurene Farley
[e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 14:25:51 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      recordcount Property

Does anyone know how to get the latest recordcount in a table ?

I tried using the following method:
Dim tabledata As Table
Set tabledata=db.opentable("Tablename")

tabledata.recordcount = recordcount in a table

However, if I were to add record to this table, the Recordcount value
is not updated to reflect the addition of the new records.

Does anyone know how to overcome this problem ? :-(

Chor Ling
[e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 15:01:00 +0100
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Sent using PMDF-822 , routing is done by ECNICE
From:         Dennis Vroegop <[e-mail]>
Subject:      Column headings

Hi,

This may very well be a stupid question, but can anyone inform me
how to change the headings above the collumns in a querie?
I don't want a collumn to be named "SumOfSales", for example, but
want to give it my own name, such as "Total of sales".

Who knows how this can be done?

VTY

Dennis Vroegop
Energy research foundation the Netherlands ECN
INTERNET [e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 15:28:00 +0100
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Sent using PMDF-822 , routing is done by ECNICE
From:         Dennis Vroegop <[e-mail]>
Subject:      Column headings

Oops, pushed that "send message" button to soon...

I also would like to know how I can format the outcome of a sum in a querie.
I have a field with sales, which are nicely formatted, but when I want
to show the totals, the format is gone. How can this be done??

VTY (again)
Dennis Vroegop
INTERNET [e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 09:15:05 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         MARK TURPIN <[e-mail]>
Subject:      Re: Column headings

  Renaming a Field in a Query

See Also



You can rename a field in a query to describe the field's data more accurately.
This is particularly useful
when you define a calculated field or calculate a total. In such cases, unless y
ou enter a name, Microsoft
Access assigns names such as Expr1 or SumOfOrder Amount.

To change a field name in a query

1       In a query's Design view, place the insertion point in front of the first lett
er of the field name in the QBE
grid.
2       Type the new name followed by a colon.
        Delete any names assigned by Microsoft Access, but don't delete the field name
or expression.

Notes

        Changing a field name in a query's Design view changes the heading in the query
's Datasheet view
and the field name in a form or report based on the query.  The underlying field
 name in the table
doesn't change, however.
        You can't use an expression name in another expression.  Its only purpose is to
 provide a name for the
datasheet column.
        If a field name includes a colon as a character in the name, you must enclose t
he name in brackets
whenever you use it in Microsoft Access.  For example, [Group: 2].


This was cut from Help.
=========================================================================
Date:         Tue, 20 Jul 1993 09:15:46 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         MARK TURPIN <[e-mail]>
Subject:      Re: Column headings

I don't think you can.
=========================================================================
Date:         Tue, 20 Jul 1993 07:26:43 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Microsoft Access for the Mac?

I herd through a co worker that the MAc version is in the works.  I'm not
sure when it will be available.  I first started hearing about the Mac
version about 4 months ago.
=========================================================================
Date:         Tue, 20 Jul 1993 07:31:01 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Column headings

To change a column heading in a query, just type what the new column
heading should be in the FIELD: column box on the QBE grid followed by a
:(colon) character.
=========================================================================
Date:         Tue, 20 Jul 1993 07:35:01 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: recordcount Property
In-Reply-To:  <[e-mail]> from "[e-mail]"
              at Jul 20, 93 02:25:51 pm

>
> Does anyone know how to get the latest recordcount in a table ?
>
> I tried using the following method:
> Dim tabledata As Table
> Set tabledata=db.opentable("Tablename")
>
> tabledata.recordcount = recordcount in a table
>
> However, if I were to add record to this table, the Recordcount value
> is not updated to reflect the addition of the new records.
>
> Does anyone know how to overcome this problem ? :-(
>
> Chor Ling
> [e-mail]
>
I believe you must do a tabledata.MoveLast prior to checking the
recordcount property.

John
=========================================================================
Date:         Tue, 20 Jul 1993 15:00:00 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John Lorenc <[e-mail]>
Subject:      MS Access on Novell Netware

We are trying to get an MS Access App going on our Novell Network.  At this
time we have not implemented MS Access Security and are relying on Novell to
deliver that.

We have 2 Novell accounts setup:  one for the super user who has full Novell
privelleges and another for users who only are suppose to have read access to
the objects.  From a Novell perspective, these usere cannot write anything to
the *.mdb files.

The problem we are encountering is that when the super user opens the
database, other users get an error about not being able to open the *.mdb
file.  Two users can access the data at the same time, provided that the
super user does not have the database open.  We have fiddled with the
Exclusive and Read Only only options to no avail.

Has anyone encountered this problem?  Any suggestions/solutions would be most
appreciated.

Thanks

John Lorenc
Information Systems Coordinator
Ontario Hydro Research
Toronto, Ontario, Canada

[e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 14:37:30 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Passing Variable Names to Access Basic

[e-mail] Wrote:
|
|
| >
| >   I'd like to be able to pass the name of a global
| variable to an Access
| > Basic function and then be able to place a value in that
| variable; e.g.
| >
| > Global SaveCurrentPartNo As String
| > SetGlobal("SaveCurrentPartNo", [PartNo])  Where:
| >
| > Function SetGlobal(MyVar As String, VarValue As String)
| >   (Contents of MyVar) = VarValue
| > End Function
| >
|         If I understand you correctely you are trying to
| pass variables by
|         reference rather then by value.  If that is
| correct I have a surprize
|         for you -- that is the default way Basic passes
| variables!
|         To pass a var by value you need to tell basic to
| do so.  In Quick Basic
|         this is done with BYVAL keyword:
|
|         Function MyFunc (BYVAL x As Integer)
|
|         Then inside you can change x and have it stay the
| same in the calling
|         invironment.
|
|         However in a default declaration:  Function MyFunc
| (x As Integer)
|         if you change the value of x inside your function
| it will also change in
|         the calling invironment.
|
|         ------------
|         But you weren't asking for this were you ... :)
|
|         Ok.  I think you can do what you want to do with
| just a straignt
|         assignment:
|
|         SavePreviousPartNo = [PartNo]
|
|         Since this var you declare as global you should be
| able to do this in
|         any piece of code in the same module.  I think you
| can do the same
|         accross modules.  But if not try looking for help
| on "COMMON" stamtent.
|
|         Good luck.
|         If I am totally off key -- let me know, may be we
| can figure out a
|         better solution.
|
|         Dmitry
|         [e-mail]
|
|

Dmitry -

  The prolem is that you don't know the name of the global variable,
i.e. it's name is in the variable passed as a parameter.  I want to set
the global variable whose name is contained in the first parameter, to
the value of the second parameter.

          Thanks   ...    [e-mail]
=========================================================================
Date:         Tue, 20 Jul 1993 19:39:32 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: Passing Variable Names to Access Basic

>   The prolem is that you don't know the name of the global variable,
> i.e. it's name is in the variable passed as a parameter.  I want to set
> the global variable whose name is contained in the first parameter, to
> the value of the second parameter.
>
>          Thanks   ...    [e-mail]


I think I understand this now (correct me, please, if I am wrong, Jeff):

You'd like to be able to pass the variable name as a string and have that
(string) interpreted to represent a variable name (or technically, just
about anything else when looking at it from an internals standpoint).
I'm guessing this isn't too unlike things one would see in the VAX/VMS/DCL
or VM/CMS/Rexx worlds...

pseudo-code example:

Pizza = 1
x$ = "Pizza = 7"
Interpret/Execute(x$)
Print Pizza
(and the output would be 7).

And you'd like to be able to do something like this, except passing parms,
etc?
No?
----------------------------------------------------
Phil Paxton
Development Editor, 7-ball juggler, etc.
SAMS/Prentice Hall Computer Publishing
CARmel, Indiana (carMEL is in California)
=========================================================================
Date:         Tue, 20 Jul 1993 17:26:15 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Access Programming

I am wondering if there is a way for an external program written in to tap
into an access table.  I realize that it is possible to write c
routines/API calls and DLL's from within access to munipulate data, but I'm
not sure if you can go the other way.  Does anyone care to share any ideas,
expirences or thoughts on this?

------------------------------------------------------
Bill Stewart
Glendale Community Collge
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date:         Tue, 20 Jul 1993 18:06:42 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re: Access Programming

On Tue, 20 Jul 1993 17:26:15 -0700 Bill Stewart writes:

>I am wondering if there is a way for an external program written in to tap
>into an access table.  I realize that it is possible to write c
>routines/API calls and DLL's from within access to munipulate data, but I'm
>not sure if you can go the other way.  Does anyone care to share any ideas,
>expirences or thoughts on this?

Have you checked out Visual Basic 3.0?  It has data aware controls,
a data access control, and the professional edition has a programmatic
layer for data access, as well.  It's native database format is the
Access .MDB.  If you are writing in C, or have an app already in C,
there may be a way to use the VB API to get at an Access table.

Robert Grinnell
Seattle Pacific University
=========================================================================
Date:         Tue, 20 Jul 1993 18:23:07 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Access Programming

>
> I am wondering if there is a way for an external program written in to tap
> into an access table.  I realize that it is possible to write c
> routines/API calls and DLL's from within access to munipulate data, but I'm
> not sure if you can go the other way.  Does anyone care to share any ideas,
> expirences or thoughts on this?
>
You can write applications in Visual Basic 3.0 that will access Access (:-))
databases. I have written several VB applications using Access databases. I
have not found anything that I cannot do in VB that I could do in Access.
Although I realize I am far from an expert in VB/Access programming. One
of the benefits(?) is that you can deliver your application to users who don't
have Access.

g.mo



-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Wed, 21 Jul 1993 09:12:56 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: recordcount Property

I use a similar method to count records in a table.  I have a control in
the form header to call the function.  It updates whenever I delete
or add a record ????????

Sorry - I guess this is not much help.

Cheers.   Graeme.
===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Wed, 21 Jul 1993 09:15:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: Column headings

I the QBE grid instead of SumOfSales as the column, put

Myname:SumOfSales    and it will alias it to Myname


Cheers.  Graeme.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Tue, 20 Jul 1993 19:35:31 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access Programming
In-Reply-To:  <[e-mail]>; from "Morris Myers" at Jul
              20, 93 6:23 pm

> > I am wondering if there is a way for an external program written in to tap
> > into an access table.  I realize that it is possible to write c
> > routines/API calls and DLL's from within access to munipulate data, but I'm
> > not sure if you can go the other way.  Does anyone care to share any ideas,
> > expirences or thoughts on this?
> >
> You can write applications in Visual Basic 3.0 that will access Access (:-))
> databases. I have written several VB applications using Access databases. I
> have not found anything that I cannot do in VB that I could do in Access.
> Although I realize I am far from an expert in VB/Access programming. One
> of the benefits(?) is that you can deliver your application to users who don't
> have Access.

Well, first, there are a number of things you can do in Access which you cannot
do in VB. Data-aware controls is one area, which despite the advancement with
VB3.0, VB actually lags in. There is no data-aware grid control, which would
be a basic datasheet in Access, nor is there a data-aware combo box or list
box. Work-arounds to achieve these features in VB turn out to be VERY slow.
You have to manually load, and then update the grid or combo box. Of course,
I haven't checked yet to see if Microhelp has their 3.0 verison of their
controls yet, though, which are supposed to provide these capabilities - but
that's more money.

Second, the Access Distribution Kit allows you to distribute your Access
applications, just as with VB. The user gets a run-time version of Access,
which hides all the design aspects of Access. The user never needs to know
they are using Access at all, and a setup kit comes with it just as with
the setup kit in VB.

Now, VB is far superior in many other ways, but my purpose here was to
respond to your specific comments.

As for accessing Access from anything but Access or VB3.0, you won't see
this in anything but Microsoft products, because the Access database engine
is a proprietary database - owned by Microsoft. Other vendors will only be
able to support Access database engines via ODBC, assuming a driver is
available, and I don't believe it is yet - there has been no demand for it.

As the first respondant indicated, the only way from C seems to be via the
use of DLL's called from an Access application. Otherwise, figure out the
binary structure of an .MDB file, and work with it just like any other file.
I don't think, again - because it is proprietary, that Microsoft will publish
this information, so you have to figure it out for yourself. BUt now you
are talking about creating your own query and update routines, which would
probably be poorly inadequate compared to the engine built into Access and VB.

Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Tue, 20 Jul 1993 22:12:34 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: recordcount Property
In-Reply-To:  Your message of Tue, 20 Jul 1993 14:25:51 +0800

I think that you have to use the MoveLast action to move to the last record
to get an accurate recourd count.  After using Table.MoveLast, use
 RC=Table.RecordCount.
=========================================================================
Date:         Tue, 20 Jul 1993 22:14:09 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Column headings
In-Reply-To:  Your message of Tue, 20 Jul 1993 15:01:00 +0100

Try NewColumnHeading:Original Column Heading as the entry in the query window
=========================================================================
Date:         Wed, 21 Jul 1993 13:57:57 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: recordcount Property

I have already replied to this request but I will list my whole
function so you can see what I have done.

The function counts the number of potential graduates in a database
that manages graduation.


Function NumberOfGraduates()
Dim db As Database
Dim Graduates As Table
Set db = CurrentDB()
Set Graduates = db.OpenTable("Graduate Data")
NumberOfGraduates = Graduates.RecordCount
End Function



I think that if you use a query rather than a table, you will
have to do a MoveFirst and a MoveLast and then interrogate
RecordCount


I hope this is of some help.

Graeme.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Wed, 21 Jul 1993 09:03:51 +0100
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         Stefan Focke <[e-mail]>
Subject:      Problem with embedded graph

Hello!

My problem is, that I cannot change the title of an embedded graph.

I have a graph based on a query witch is embedded in a form. The title of
this graph is always the name of the first field in the query. When I open
MS-Graph I am able to change this title to a new text, but when I use the
form the old title appears again. It also seems to be impossible to delete
the title.

Any hints?

Thank you

----------------------------------------------------------------------

Stefan Focke                  Tel. [phone]
GMD-ISA                       e-mail: [e-mail]
Rathausalle 10
D-W 5205 Sankt Augustin 1

    ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Wed, 21 Jul 1993 06:50:49 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Eugene Levine <[e-mail]>
Subject:      Dates and File Transfers
In-Reply-To:  <[e-mail]>

In transferring data from Mac Excel to Windows Excel to Access, my dates
appear to be off by four years (correct date = 1990; Access date after
transfer = 1994). Does anyone know why this is happening and whether there
is a fix?

Thanks in advance.

Gene
[e-mail]
=========================================================================
Date:         Wed, 21 Jul 1993 10:14:35 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: Access Programming

> Although I realize I am far from an expert in VB/Access programming. One
> of the benefits(?) is that you can deliver your application to users who
don't
> have Access.

This last part is a non-issue because of ADK.  With ADK, you can distribute
your
Access applications royalty-free.  After making the initial purchase, of
course.

It's interesting...I received a phone call from a survey company on behalf
of Microsoft
last week asking how much I thought would be a fair price as a royalty for
distributing
applications (Hmmmmm). Unfortunately, 99% of the questions were yes/no and
allowed
no room for commentary.  My comments during the essay portion of the test
were of the
effect I believed if Microsoft started charging royalties for ADK
distribution [that] the
ADK should not be *sold* to the developer community and it most certainly
would sway
my decisions regarding which platform is used for development.

I suppose Wheel of Fortune could say it best:

                    G R __ __ D

     "Pat, could I buy an E?"



Phil Paxton
Development Editor, eidetic, and seven-ball juggler.
=========================================================================
Date:         Wed, 21 Jul 1993 16:24:06 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Hilger Robert <[e-mail]>
Subject:      Re: Dates and File Transfers

 E> In transferring data from Mac Excel to Windows Excel to Access, my
 E> dates appear to be off by four years (correct date = 1990; Access date
 E> after transfer = 1994). Does anyone know why this is happening and
 E> whether there is a fix?
 E>
 E> Thanks in advance.
 E>
 E> Gene
 E> [e-mail]
***** NOTES from Hilger Robert (RHILGER @ KPMG) at 21.07.93 16:12
The MAC uses Dates beginning with 1904, the PC starts at 1900.
There is a check-box in Extras - Calculate named *1904 Date values* (may be
not exact - I use a german version).

Check this out (or on?)
HTHs
Robert



Robert Hilger       ==\\
[e-mail]____//_
      ____      /      O\
  O|_|    \____/ Pegaso /
 /__    __          __ /
/  +++++  \        /  +++++
 ++  _  ++ \      / ++  _  ++
++  / \  ++ \____/ ++  / \  ++
++  \_/  ++        ++  \_/  ++
 ++     ++          ++     ++
   +++++              +++++
two wheels are enough
=========================================================================
Date:         Wed, 21 Jul 1993 07:48:49 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Passing Variable Names to Access Basic

[e-mail] Wrote:
|
|
| >   The prolem is that you don't know the name of the global
| variable,
| > i.e. it's name is in the variable passed as a parameter.  I
| want to set
| > the global variable whose name is contained in the first
| parameter, to
| > the value of the second parameter.
| >
| >          Thanks   ...    [e-mail]
|
|
| I think I understand this now (correct me, please, if I am
| wrong, Jeff):
|
| You'd like to be able to pass the variable name as a string
| and have that
| (string) interpreted to represent a variable name (or
| technically, just
| about anything else when looking at it from an internals
| standpoint).
| I'm guessing this isn't too unlike things one would see in
| the VAX/VMS/DCL
| or VM/CMS/Rexx worlds...
|
| pseudo-code example:
|
| Pizza = 1
| x$ = "Pizza = 7"
| Interpret/Execute(x$)
| Print Pizza
| (and the output would be 7).
|
| And you'd like to be able to do something like this, except
| passing parms,
| etc?
| No?
| ----------------------------------------------------
| Phil Paxton
| Development Editor, 7-ball juggler, etc.
| SAMS/Prentice Hall Computer Publishing
| CARmel, Indiana (carMEL is in California)
|
|

Phil -

  Almost.  I would like to do what you describe (and can't do that
either).   However, in this case I am trying to do something like:

x$ = "Pizza"
y% = 27
replace variable whose name is in x$ with y%.

  In XBASE you would use "macros"; e.g.
x = "Pizza"
&x = y

                 ... [e-mail]
=========================================================================
Date:         Wed, 21 Jul 1993 12:40:58 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: Passing Variable Names to Access Basic

| Pizza = 1
| x$ = "Pizza = 7"
| Interpret/Execute(x$)
| Print Pizza
| (and the output would be 7).
|
| And you'd like to be able to do something like this, except
| passing parms,

>   Almost.  I would like to do what you describe (and can't do that
> either).   However, in this case I am trying to do something like:
>
> x$ = "Pizza"
> y% = 27
>replace variable whose name is in x$ with y%.
>
>   In XBASE you would use "macros"; e.g.
> x = "Pizza"
> &x = y

Hmmm. Ok. I understand now.  I don't think you can do it -- there'd need to be
 an interpretation performed
against the parms and I don't think Access has that ability (yet).  I've not
 seen this on the "wishlist" section
of the Access forum yet -- I wonder 1) if any serious consideration would be
 given to it and 2) how it would
mess up the internals to permit such a feat?

Phil Paxton
Development Editor, 7-ball juggler, and eidetic
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Wed, 21 Jul 1993 15:57:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Resent-From: Nathan Brindle <NBRINDLE@INDYCMS>
Comments:     Originally-From: Jeff Bone <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: UAB Photo & Graphics
Subject:      TAN:  Recent Aldus Press Release

Hi all--I'm forwarding this off of PAGEMAKR@INDYCMS because it might
be useful for some of you.  Note that it specifically mentions Access.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------

----------------------------Original message----------------------------
Aldus Announces InfoPublisher Database Addition

SEATTLE, June 29, 1993--Aldus Corporation today announced the InfoPublisher
Database Addition, an application that links Aldus PageMaker 5.0 for Windows
to database management systems. InfoPublisher, an upgrade to PageMaker 4.0
Database Edition, is developed by PageAhead Software Corporation, Seattle.

InfoPublisher will offer an intuitive, spreadsheet-like interface that
customers can use with the pasteboard interface in PageMaker. They can then
easily query, retrieve, and format information from popular database formats
and place it in publications they produce with PageMaker. Users will be able
to combine data from multiple database tables, calculate new fields based on
any data in a database, and sort the data in practically any order.

"With the InfoPublisher Database Addition, people will be able to place raw
data from dBASE, Paradox, FoxPro, or Access as well as Excel and ASCII text
files right into PageMaker to present their information in an attractive,
professional-looking publication," said Karen Howe, Aldus Additions senior
product manager. "This new release will extend PageMaker's publishing power by
supporting data from leading database systems, with much tighter integration
between PageMaker and the InfoPublisher interface."

The Aldus Additions family

"The InfoPublisher Addition is just one of many Aldus Additions tailored to
the specific publishing needs of today's PageMaker user," Howe said.
"Additions are add-on modules to PageMaker that automate routine and
repetitive tasks or enable users to customize PageMaker for their specialized
publishing requirements."

Several Additions are included with the retail versions of PageMaker; others
can be purchased separately. InfoPublisher will be the first standalone
Addition for PageMaker 5.0.

System configuration

The InfoPublisher Database Addition for Aldus PageMaker 5.0 will require
Microsoft Windows 3.1 or later and Windows 3.1-compatible hardware. The
recommended configuration will be a 486-based DOS-compatible computer, 6-8MB
of RAM, an 80MB hard drive, a high-resolution graphics adaptor card, and a
mouse. The minimum configuration will be a 386-based DOS-compatible computer,
6MB of RAM, a 40MB hard drive, an EGA or Hercules graphics adaptor card, and a
mouse or other pointing device.

Availability and pricing

InfoPublisher Database Addition for Aldus PageMaker 5.0 will be released in
the third quarter of 1993, with a suggested retail price of $199 (U.S.).
Registered owners of Aldus PageMaker 4.0 Database Edition will be able to
upgrade by purchasing the InfoPublisher Database Addition for $79. Customers
who purchase Database Edition after June 29, 1993 will receive the
InfoPublisher Addition as a free upgrade. Customers who order through Aldus
Customer Services between now and October 31, 1993 can receive the Addition at
the special introductory price of $129.

To receive more information on the InfoPublisher Database Addition, or Aldus
PageMaker 5.0, customers in the United States and Canada can contact Aldus
Customer Services at [phone].

Aldus Corporation (NASDAQ: ALDC) creates computer software solutions that help
people throughout the world effectively communicate information and ideas. The
company focuses on three lines of business: applications for the professional
publishing and prepress markets; applications for the general consumer market;
and service and support programs for professional end-users. Aldus has
subsidiaries in Europe, Asia, and the Pacific Rim serving a worldwide network
of dealers and distributors.

Aldus, the Aldus logo, and PageMaker are registered trademarks of Aldus
Corporation. InfoPublisher is a registered trademark of PageAhead Software
Corporation. Other product and corporate names may be trademarks or registered
trademarks of other companies, and are used only for explanation and to the
owners' benefit, without intent to infringe.



--------------------------------------------------------------------
Jeff Bone                              Internet: [e-mail]
Electronic Imaging Coordinator        AppleLink: jbone
School of Medicine                          FTP: ftp.dopig.uab.edu
University of Alabama at Birmingham       Voice: [phone]
University Station                          Fax: [phone]
Birmingham, AL  35294-2041                 Data: [phone]
=========================================================================
Date:         Wed, 21 Jul 1993 15:35:47 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Microsoft Access for the Mac?
In-Reply-To:  <[e-mail]> from "Roger Lurie" at
              Jul 18, 93 03:56:01 pm

>
> Does anyone know if Microsoft plans to develop a copy of Access for the
> Macintosh?
>
> -------------------------------------------------------------------------
> Roger Lurie
> Arizona State University, Administrative Information Technology
> Tempe, Arizona  85287-0101
> Telephone: [phone]             Fax:    [phone]
> Internet:  [e-mail]  Bitnet: icsral@asuacad
> -------------------------------------------------------------------------
>
    I think that is a good bet.  Microsoft said in the last Developers Newspaper
    that the new Visual Basic Application Edition will run on Win3.1 WinNT and
    Macintosh.  The plans for the VB are very ambitious -- it is to be a
    universal macro control languauge for all Microsoft Applications and it
    will handle OLE2.0 as its main goal.
    Microsoft also said that they see a new area of computer programmers:
    solution providers who will take the off-the-shelf software and program its
    exposed objects using VB to produce a complete solution for a customer in
    a very short time.  As an example they gave a financial package based on
    Excel and Word.

    Of cource I am not assosiated with MS except that I make my living
    using their applications.

    Dmitry
    dmitry.ucsee.berkeley.edu
=========================================================================
Date:         Wed, 21 Jul 1993 15:44:18 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Formating results of expressions
In-Reply-To:  <[e-mail]> from "Dennis Vroegop" at
              Jul 20, 93 03:28:00 pm

>
> Oops, pushed that "send message" button to soon...
>
> I also would like to know how I can format the outcome of a sum in a querie.
> I have a field with sales, which are nicely formatted, but when I want
> to show the totals, the format is gone. How can this be done??
>
    Look for help on Format and Format$ function.
    They let you use the same syntax as in the Format property in a form or
    table (or report), but just work on values instead.  So if you have an
    expression that returns a value (say A+B) do this:

    =Format("#,##0.00", A+B)

    I am not sure about syntax but this is definetely possible.
    Good luck.
=========================================================================
Date:         Wed, 21 Jul 1993 16:21:00 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Requery problems

Okay, here's the scenario:

On Form A, I have a combo box which lists all the key index values of that
form, and which allows the selection of any given record (just like on the
Supplier form of the MS-provided Northwind demo database).

Also on this form is a button, which calls a macro to open another form for
the purpose of adding a new record to this table. It opens it up as a dialog
form (modal). After adding the new record, and the new form is closed, I
do a REQUERY command, with no parameter, hoping to update Form A so that
the record I just added shows up in my combo box.

Doesn't work.

Now, first, I've done this before, and I worked - at least I thought it did.
Second, I've tried issuing the REQUERY command in the same macro that
opens up the modal data-entry form, and also as part of the macro that
closes that same form. In either case, I don't get an error or anything,
but it just does not work. Like I say, I thought I had this working in a
similar situation once, but it doesn't seem to be now.

Thanks in advance for any help.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 21 Jul 1993 21:28:00 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John M. King" <[e-mail]>

I have an access application in which it is necessary to convert a table
which contains 4 memo fields to one in which the data in the memo fields
is contained in Word documents embedded in OLE fields.  I am trying to
write a function(s) which would accomplish the conversion of the data
without the necessity of user intervention.

My current approach is to write a function which reads each memo field,
writes it to a text file, calls another function which inserts the
object, a word document into the OLE field, inserts the txt file into
the word document using word basic commands, closes the document and
continues on until the end of the table.

I have gotten parts of it to work and will likely get it all to work
eventually.  But it is not very elegant and does not yet work.  I would
appreciate any comments and/or suggestions as to how best to accomplish
this task.

John King
Cap Gemini America                      Fax   [phone]
[e-mail]                  CompuServe 72060,3706
=========================================================================
Date:         Thu, 22 Jul 1993 09:26:31 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: recordcount Property

To all my advisers,

Thanks you. I tried MoveLast Method. However, the recordcount is still wrong.
Presently, I am using version 1.0. Maybe version 1.1 will not have this "bug".
I will keep U inform if I ever find a way besides manual counting.

Chor Ling
=========================================================================
Date:         Wed, 21 Jul 1993 22:51:21 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Requery problem sort of solved

Well, I'm going to answer my own problem, since I seem to have it
working.

FIrst, to clarify, I did try requerying just the control in question, and
it didn't seem to work either. What _is_ working is doing first a refresh
and then a requery. A requery alone wasn't working at all. A refresh alone
seemed to sort of work, but not completely. The two together seem to do
the job. I still think there's some hidden reason why one or the other isn't
working for me, but at least it is working.

Wierd.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 21 Jul 1993 22:57:13 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Indexing in Access?

I had never bothered indexing in Access, since everything runs pretty
quick for me (of course, the keys are indexed, but they always are).
Anyway, I am doing some queryies based on queries now (in order to get
around not being able to do nested SQL queries in Access), and am seeing
a few queries that take a few seconds, instead of being instant. SO, I
figured I'd maybe index the fields involved, since the docs indicate that
indexing speeds up searches and sorts, and guess what - nothing happened.
Indexing the fields involved didn't seem to do a thing.

So, my question is:

1. What's the point?

2. Does anyone else use indexing successfully?

I'm used to dBase and FoxPro where an index can make all the difference
in the world, but in those products, you have direct control over whether
and how use an index in your queries. In Access, there's no such control
from the query design, no "use indexes" flag or anything, so how am I to
know that Access is always using an index where possible? It just doesn't
seem to be doing anything for me. Does it matter that they are
Duplicates OK indexes? They have to be in this situation.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 22 Jul 1993 09:05:01 +0100
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         Stefan Focke <[e-mail]>
Subject:      Re: Formating results of expressions

> Oops, pushed that "send message" button to soon...
>
> I also would like to know how I can format the outcome of a sum in a querie.
> I have a field with sales, which are nicely formatted, but when I want
> to show the totals, the format is gone. How can this be done??


If I understand your Problem right, you should make a form with the field
you want to display. Change the format of this fields and show the form in
table-mode.

Greetings

Stefan

----------------------------------------------------------------------

Stefan Focke                  Tel. [phone]
GMD-ISA                       e-mail: [e-mail]
Rathausalle 10
D-W 5205 Sankt Augustin 1

    ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Thu, 22 Jul 1993 14:59:38 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Password-command

Hi!

Two questions:

1) Is there another way to put Access-commands into user-defined menus than
to put menus into a form? It seems to me that I always need sort of a
"background"-form in order to have any kin dof menu.

2) Is there a way to put the password-command into a menu other than to
make the database-container visible?

Thanks for any help!!

Martin
=========================================================================
Date:         Thu, 22 Jul 1993 15:09:06 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Re: Indexing in Access?

Hi!

I can tell from my experience with Access and VB3.0 that using an index
speeds up things very much.

Example:
I made a VB-procedure that used a query to find select about 200 items in a
2000 items listbox (to where my procedure transferred the records). It took
about 7 seconds to select all 200 items.

I thought it was mainly VB's fault but then I switched from running the
query to using the table itself with its PrimaryKey and voila: less than a
second to select all items! That's a difference, isn't it?

Maybe switching from a query (FindFirst, FindNext and so on) to a table
(Table.Index = "PrimaryKey" and Table.seek "=", condition) with an Index
can help you too??

Regards

Martin
=========================================================================
Date:         Thu, 22 Jul 1993 13:46:33 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Stultz <[e-mail]>
Subject:      Access Speed?

I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
have been having some problems with speed.  I have a 386-DX/33 Mhz with 4 Megs
of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
access.  I am trying to write a database for a baseball card collection, and
every single action I make takes at least a few seconds, if not longer.  I
have attached buttons to macros which run queries, and when I run them, the
hourglass icon appears for up to thirty seconds.  Is there anything I can do
to speed this harrowing process up?
        Dave Stultz
        [e-mail]

p.s.
        I don't have a math co-processor - could having one make that much of
a difference?
=========================================================================
Date:         Thu, 22 Jul 1993 13:58:42 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Organization: PictureTel Corporation
Subject:      Re: Access Speed?

>
> I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
> have been having some problems with speed.  I have a 386-DX/33 Mhz with 4 Megs
> of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
> access.  I am trying to write a database for a baseball card collection, and
> every single action I make takes at least a few seconds, if not longer.  I
> have attached buttons to macros which run queries, and when I run them, the
> hourglass icon appears for up to thirty seconds.  Is there anything I can do
> to speed this harrowing process up?
>         Dave Stultz
>         [e-mail]
>
> p.s.
>         I don't have a math co-processor - could having one make that much of
> a difference?
>

Your system is similar to mine. When I started working on my first,
Access application, I used to macros. After I became incredibly
frustrated over the difficulty of maintaining macros, I started
converting all of my code to Access Basic. Unexpectedly, I was
rewarded with much better performance with my application.

I would recommend against using macros for the most part. If I didn't
have to use macros for Autoexec and custom menus, I wouldn't have
any macros at all.

--

Steve Miller    x235
=========================================================================
Date:         Thu, 22 Jul 1993 14:49:59 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Access Speed?

> I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
> have been having some problems with speed.  I have a 386-DX/33 Mhz with 4 Megs
> of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
> access.  I am trying to write a database for a baseball card collection, and
> every single action I make takes at least a few seconds, if not longer.  I
> have attached buttons to macros which run queries, and when I run them, the
> hourglass icon appears for up to thirty seconds.  Is there anything I can do
> to speed this harrowing process up?
>         Dave Stultz
>        [e-mail]
>
> p.s.
>        I don't have a math co-processor - could having one make that much of
>a difference?


Dave, the rule of thumb I've heard circulated the most (and endorsed by
 Microsoft) is adding 4Mg of memory
to a 386 (that already has 4Mg -- for a total of 8M) will increase Access
 performance significantly more than
migrating to a 486 that only has 4Mg.


Phil Paxton
Development Editor, eidetic, and 7-ball juggler
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 22 Jul 1993 15:38:47 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      Re: Touch-sensitive screens w/ACCESS
In-Reply-To:  Message of Mon,
              19 Jul 1993 08:27:16 -0600 from <[e-mail]>

Yes,
    Touch screens use mouse drivers what is the problem?
                                                       Greg
=========================================================================
Date:         Thu, 22 Jul 1993 14:38:12 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         FRED CHIN <[e-mail]>
Subject:      Re: Access Speed?
In-Reply-To:  <[e-mail]>; from "Steve Miller" at Jul
              22, 93 1:58 pm

>
> >
> > I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
> > have been having some problems with speed.  I have a 386-DX/33 Mhz with 4 Me
gs
> > of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
> > access.  I am trying to write a database for a baseball card collection, and
> > every single action I make takes at least a few seconds, if not longer.  I
> > have attached buttons to macros which run queries, and when I run them, the
> > hourglass icon appears for up to thirty seconds.  Is there anything I can do
> > to speed this harrowing process up?
> >         Dave Stultz
> >         [e-mail]
> >
> > p.s.
> >         I don't have a math co-processor - could having one make that much o
f
> > a difference?

Yes! Increase your memory to 8MB...It is a significant sppedup to me...I had
compare a 386SX16 with 8MB against 386DX40 with 4MB....you can see the harddisk
working very hard on the 4MB machine...the bad news is...the SIMMS price just
jump 100-120% since last month...

Fred Chin
[e-mail]
=========================================================================
Date:         Thu, 22 Jul 1993 17:49:49 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Memo field to MS-Word

>
> I have an access application in which it is necessary to convert a table
> which contains 4 memo fields to one in which the data in the memo fields
> is contained in Word documents embedded in OLE fields.  I am trying to
> write a function(s) which would accomplish the conversion of the data
> without the necessity of user intervention.
>
> My current approach is to write a function which reads each memo field,
> writes it to a text file, calls another function which inserts the
> object, a word document into the OLE field, inserts the txt file into
> the word document using word basic commands, closes the document and
> continues on until the end of the table.
>
> I have gotten parts of it to work and will likely get it all to work
> eventually.  But it is not very elegant and does not yet work.  I would
> appreciate any comments and/or suggestions as to how best to accomplish
> this task.
>
> John King
> Cap Gemini America                      Fax   [phone]
> [e-mail]                  CompuServe 72060,3706
>
    I donno, if you can put a word document in the OLE field from the function
    and you can open it in some way so you are able to use WordBasic to load
    text, then perhaps you could just use clip board to cut the text from the
    memo field and paste it in the word document?..  This will save you some
    time and you may be able to do all this without flashing a bunch of windows
    in front of the user.  The size of the text might be limited for clipboard,
    but I don't think so.
    Just a thought.

    Good luck.
    [e-mail]
=========================================================================
Date:         Thu, 22 Jul 1993 18:06:31 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Access Speed?
In-Reply-To:  <[e-mail]> from "Dave Stultz" at
              Jul 22, 93 01:46:33 pm

>
> I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
> have been having some problems with speed.  I have a 386-DX/33 Mhz with 4 Megs
> of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
> access.  I am trying to write a database for a baseball card collection, and
> every single action I make takes at least a few seconds, if not longer.  I
> have attached buttons to macros which run queries, and when I run them, the
> hourglass icon appears for up to thirty seconds.  Is there anything I can do
> to speed this harrowing process up?
>         Dave Stultz
>         [e-mail]
>
> p.s.
>         I don't have a math co-processor - could having one make that much of
> a difference?
>

        8 Meg!  It made all the difference for me, and I have the same setup
        you do.  Also once I got 8Meg I was able to get SmartDrv going up to
        2 K and that was when I got the speed increace.  I think it is something
        of a sin but I have now 16 Megobyte Permanent Swap File!  I constantly
        have ~15Meg free under windows. Running two instances of Access and
        MS Word is also unheard of with my previous setup.

        Math chip will help only if you do floating point math in you query
        conditions.

Good luck.
[e-mail]
=========================================================================
Date:         Fri, 23 Jul 1993 09:12:48 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Problem with embedded graph

Dear Stefan,

After opening the form, do requery the title of this graph. Microsoft Access
does not automatically update the title for U everytime U open the form.

Assuming the title of this graph is a textbox called title
If U are using Macro this is a command requery.
If U are programming, use repaintobject A_FORM, "Form Name"

I hope it helps.

Chor Ling
=========================================================================
Date:         Fri, 23 Jul 1993 09:25:45 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: recordcount Property

Dear Graeme,

Thanks for your code. I wrote EXACTLY the SAME code BEFORE ( except different
variable name). However, this particular table DOESN'T work. I know that
it is HARD to belive, but :-( it is true.

Just now, I imported this "Particular Table" and the code to a new database.
I get the correct recordcount. The table data in these 2 databases is
EXACTLY the same. I am convince that Microsoft Access is NOT consistent.

If I have time to spare, I will like to find out WHY.

Anyway, thanks again.

Chor Ling
[e-mail]
=========================================================================
Date:         Thu, 22 Jul 1993 22:14:38 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Brian Hurley <[e-mail]>
Subject:      Re: Access Speed?
In-Reply-To:  <[e-mail]>; from "Dave Stultz" at Jul 22,
              93 1:46 pm

>
> access.  I am trying to write a database for a baseball card collection, and
> every single action I make takes at least a few seconds, if not longer.  I
> have attached buttons to macros which run queries, and when I run them, the
> hourglass icon appears for up to thirty seconds.  Is there anything I can do
> to speed this harrowing process up?

RAM! RAM! RAM!

Get as much as you can afford.  I use a slow 386dx20 at work and have 8M Ram
10M swap (with a slow HD), and the only thing that takes a long time is a
large query.  Everything else is almost instant.  Also, make sure you have a
HD cache like smartdrv.


> p.s.
>         I don't have a math co-processor - could having one make that much of
> a difference?
>

I doubt it but it couldn't hurt.   There only around $70 now...

Brian

--
----------------------------------------------------------------------------
| Brian Hurley          | Internet: [e-mail]                     |
|                       | Fidonet : [e-mail] |
----------------------------------------------------------------------------
=========================================================================
Date:         Fri, 23 Jul 1993 11:06:10 GMT0BST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Aiken <[e-mail]>
Subject:      ADK, On top, Sharing with VB.

Sorry if you have already received this message but I'm having
problems with our SMTP gateway! (And I'm in idiot mode this week!)

Three questions:-

1. what on earth is the ADK. And how do I get it? Do I need it?

2. In VB can and how do you make something be 'Always on
Top'. (bit like the clock in Win 3.1)

3. A puzzler :-

I have an access Database in shared mode etc. I have written a small
VB app that checks a table in this database every 20 minutes. The
problem is that if access has the File open, the VB app cannot open
it. VB opens the table with Exclusive set to FALSE and in
READ_ONLY mode. When it tries to refresh the table (i.e. open it) it
says something about it cannot open the file! I have the security stuff
on and have tried it with VB using the same ID as access and a
different.

Running Multiple VB apps appears to work. I can't really tell since
once it gets the record count it closes the table (& database) down.

Any ideas out there?

If the code will help let me know!

PS : Excellent list. BEST I've seen.
PPS: Don't know if its VB or ACCESS. So I'm sending it to this list.
Anyone know a VB or VC++ list I could join

Many thanks is advance.


David Aiken
(Windows / Network Development)

    Tel : (+44) [phone]
    Fax : (+44) [phone]
-----------------------------------------------------
=========================================================================
Date:         Fri, 23 Jul 1993 07:04:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DAVID FARR <[e-mail]>
Subject:      ACCESS SPEED

I have used Access on a couple of 386-25 computers, with 4, 6 and 8 megs of
memory.  Even with 4 my performance did not appear to be as poor as you
report.  Increasing the amount of memory does definately improve performance.
Worth the extra cost until the recent increase in memory prices.  As mentioned
previously having 8megs of memory is important regardless of the cpu.
I have also changed a 486-50 from 4 to 8 megs and the improved performance
was quite obvious.
                Dave Farr
                  [e-mail]
=========================================================================
Date:         Fri, 23 Jul 1993 10:41:33 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      ADK, On top, Sharing with VB.

> 1. what on earth is the ADK. And how do I get it? Do I need it?

<A>ccess <D>istribution <K>it.  It's an Access runtime package which allows you
 to distribute copies of
Access applications (royalty-free, for now) and the user won't have to already
 have a full copy of Access.
What this means is [that] they can't get into design mode or anything like that,
 so you really have to cover
your bases.  Here in the US, I think it's $495 for the initial purchase.  It
 also comes with a SETUP program
to help you create "install disks" for your application.

As far as "do I need it?" goes, it depends upon your circumstances.  If you
 write and distribute applications
and don't want to hassle with relying upon your end-users to have a copy of
 Acces, go for it.  There are
some considerations for writing applications using the ADK, including the fact
 macros cannot error-trap so
you must use modules; if you want flexibility in queries and reports, you may
 need to write your own wizards
(query wizards are way-cool!), etc.

> 2. In VB can and how do you make something be 'Always on
> Top'. (bit like the clock in Win 3.1)

I've not looked at VB for awhile, but from a general Windows programming (I've
 got C++ on the brain as of
late), here's the Borland/OWL solution:

Instead of using CreateWindow, use CreateWindowEx.  Make sure the style parm
 WS_EX_TOPMOST is
passed.  Also, you need to call the SetWindowPos function and pass HWND_TOPMOST.



Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Fri, 23 Jul 1993 08:22:33 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Speed?
In-Reply-To:  <[e-mail]> from "Phillip" at Jul 22,
              93 02:49:59 pm

Phil,

Microsoft has a document on improving speed on 4 meg machines.  You
might want to request it from phone support.

Also, if you are planning to buy RAM, prepare to be surprised.  A
Sumimoto chemical plant in Japan burned down.  It supplied 60% of the
epoxy resin for Japanese IC's.  Prices are going through the ceiling.

John
=========================================================================
Date:         Fri, 23 Jul 1993 12:38:45 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Stultz <[e-mail]>
Subject:      Speed

Thanks to everyone for their help.  I found that by disabling my one meg
smartdrive, Access could use about 3 megs of memory, which did speed things up
a bit.  I also added the Share command to my config.sys file.  Without extra
memory, these two things seemed to allow Access to run more smoothly.

        -Dave Stultz
        [e-mail]
=========================================================================
Date:         Fri, 23 Jul 1993 13:40:36 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: ADK, On top, Sharing with VB.
In-Reply-To:  Message of Fri,
              23 Jul 1993 10:41:33 EDT from <[e-mail]>

On Fri, 23 Jul 1993 10:41:33 EDT Phillip (Phil) Paxton said:
>  Here in the US, I think it's $495 for the initial purchase.

We found a mail order source...the ADK cost us under $300.

Another consideration would be the disk space on the drives that would need
your programs.  The runtime would obviously use less of it.

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Fri, 23 Jul 1993 09:17:04 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jeff=[e-mail]
Subject:      Re: Passing Variable Names to Access Basic

[e-mail] Wrote:
|
|
|| Pizza = 1
|| x$ = "Pizza = 7"
|| Interpret/Execute(x$)
|| Print Pizza
|| (and the output would be 7).
||
|| And you'd like to be able to do something like this, except
|| passing parms,
|
| >   Almost.  I would like to do what you describe (and
| can't do that
| > either).   However, in this case I am trying to do
| something like:
| >
| > x$ = "Pizza"
| > y% = 27
| >replace variable whose name is in x$ with y%.
| >
| >   In XBASE you would use "macros"; e.g.
| > x = "Pizza"
| > &x = y
|
| Hmmm. Ok. I understand now.  I don't think you can do it
| -- there'd need to be
|  an interpretation performed
| against the parms and I don't think Access has that
| ability (yet).  I've not
|  seen this on the "wishlist" section
| of the Access forum yet -- I wonder 1) if any serious
| consideration would be
|  given to it and 2) how it would
| mess up the internals to permit such a feat?
|
| Phil Paxton
| Development Editor, 7-ball juggler, and eidetic
| SAMS/Prentice Hall Computer Publishing
| Carmel, Indiana
|
|

Phil -

  I find that I write many similar functions/screen/reports in a Single
Access application because there is no way to generalize them, passing
parameters that specify the unique properties of a specific instance.
  The lack of the ability to reference variables whose names are stored
in variables, limits the degree to which common modules can be
employed. This seems like a significant shortcoming to me.

              ... [e-mail]
=========================================================================
Date:         Fri, 23 Jul 1993 12:15:50 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: Access Speed?

> Microsoft has a document on improving speed on 4 meg machines.  You
> might want to request it from phone support.

I think you got your wires crossed -- I was the one who posted increasing
memory instead of just replacing the CPU...

> Also, if you are planning to buy RAM, prepare to be surprised.  A
> Sumimoto chemical plant in Japan burned down.  It supplied 60% of the
> epoxy resin for Japanese IC's.  Prices are going through the ceiling.


it's not just 60% of the Japanese ICs...it's more like 60% of the world's
 supplier...



Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Fri, 23 Jul 1993 12:48:45 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access Speed?
In-Reply-To:  <[e-mail]>; from "Phillip" at Jul 23,
              93 12:15 pm

> > Also, if you are planning to buy RAM, prepare to be surprised.  A
> > Sumimoto chemical plant in Japan burned down.  It supplied 60% of the
> > epoxy resin for Japanese IC's.  Prices are going through the ceiling.
>
>
> it's not just 60% of the Japanese ICs...it's more like 60% of the world's
>  supplier...

Actually, from what I heard, the situation is not nearly as bad in N.America
and Europe, where there is another major supplier which should be able to
pick up _most_ of the slack. I heard that Japan and the other Asian
countries (like Taiwan) are going to be hit much harder by this. In addition,
most companies keep about a 2 month supply of the stuff on hand. Between
this, increased capacity (hopefully) with the other major supplier, and
Sumitomo coming back on line, things should be OK soon enough, but there
could indeed be a few months of trouble ahead.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Fri, 23 Jul 1993 23:21:02 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kha Tran <[e-mail]>
Subject:      Access Distribution Kit on a 4MB system...

Hi,

Is the speed of Access applications produced by ADK fast enough
on a 386DX33 system with 4MB RAM?  I plan to convert a budget application
I wrote for a customer in Excel to Access.  Currently the Excel application
is slow, but acceptable.  I want to convert to Access because the customer
wants more features and better speed.  Also because I hate the thought of
writing another line of Excel macro.  ;-))  I cannot wait for Excel 5.0
either.

1- Should I convert the application to Access?  Will the new Access application
run faster than the old Excel application?   The customer doesn't need to
do any design or programming work, therefore I consider getting the ADK to
generate multiple copies of my application for the customer's company.

2 - Will the Access application generated by ADK work exactly as it would
in a normal Access system before it was generated?

3 - By the way, should I use Visual Basic 3.0 instead of Access?  My
application is not very fancy.  It juss need a relational database and
a form designer that supports "continous form" data entry form.  Can Visual
Basic support continous form based on a table or query?  (by continous form
I mean the form style showing a set of table rows concurrently.)

Thanks,

Kha
[e-mail]
=========================================================================
Date:         Fri, 23 Jul 1993 16:16:38 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      Re: Access Speed?
In-Reply-To:  Message of Thu, 22 Jul 1993 14:38:12 PDT from <[e-mail]>

I believe that the JAPAN memory maker catching on fire is BS.  Has anyone
seen photos of the burnt SIMMS plant?

Regards,
        greg
=========================================================================
Date:         Sat, 24 Jul 1993 14:27:24 +0800
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Paul Templeman <[e-mail]>
Organization: Sequel Technology
Subject:      MS Access SDK Security query

I'm developing an application to be distributed to users using the Access
Distribution Kit and wondering how I can prevent other Access development
systems being able to change the tables ,e.g. licencing info etc. and being
able to change the code. Is it as simple as creating a new workgroup and
then changing the workgroups admin password ?

Paul...

--
Paul Templeman                Sequel Technology      Phone : [phone]
Technical Director            16 Bloodwood Circle    Fax   : [phone]
[e-mail]     South Lake  6164       Pager : [phone]
                              Western Australia
=========================================================================
Date:         Sat, 24 Jul 1993 17:29:47 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: Access Speed?

> I believe that the JAPAN memory maker catching on fire is BS.  Has anyone
> seen photos of the burnt SIMMS plant?

> Regards,
>         greg



There was a lot of news coverage about the fire.  I saw lots of photos...but
 wait!  Maybe those were forged
to make me think it was a fire (the special effects *were* pretty good)...thus
 causing a run on the market
and potentially causing a stock market crash...

P.S.

Help! Help!  The paranoids are out to get me!
=========================================================================
Date:         Mon, 26 Jul 1993 09:03:21 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Undocumented feature in Access

I have recently found what I believe to be an undocumented feature
(you all know what that means) in Access.

I have a function that opens a table and returns the value of
recordcount.  This was working fine until it suddenly began to
return a value that was one third of what it should be.  I checked
everything I could and found no error.

Then I compacted the database.

Bingo!  The function was suddenly returning the correct value.
Dead clever programming if you ask me.

????????

Cheers.    Graeme.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Mon, 26 Jul 1993 12:59:30 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "abdulrahman. ahmad" <[e-mail]>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      ok

ok
=========================================================================
Date:         Mon, 26 Jul 1993 08:21:43 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John D. Mireley" <[e-mail]>
Subject:      Re: Access Speed?

----- Begin Included Message -----

> I believe that the JAPAN memory maker catching on fire is BS.  Has anyone
> seen photos of the burnt SIMMS plant?

> Regards,
>         greg



There was a lot of news coverage about the fire.  I saw lots of photos...but
 wait!  Maybe those were forged
to make me think it was a fire (the special effects *were* pretty good)...thus
 causing a run on the market
and potentially causing a stock market crash...
----- End Included Message -----

The fire was at a plant the makes resigns used in the manufature of IC's.
The plant was a third source for Intel and other US IC manfs. It's unlikely
that it would really affect Memory availability. That's not to say
simm manfs might not do some gouging to take advantage of the misinformation
about the impact of the fire
.
=========================================================================
Date:         Mon, 26 Jul 1993 08:41:09 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Access Speed?
In-Reply-To:  Message of Mon,
              26 Jul 1993 08:21:43 EDT from <[e-mail].M SU.EDU>

I will add only that the price of SIMMs on-shelf has doubled here in many
outlets...these being SIMMs that were ALREADY on the shelf...and ask that
this thread please end here or continue in private mail.

Thanks,
Nathan Brindle
List Administrator, ACCESS-L

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 26 Jul 1993 07:03:57 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Access Speed?

> ----- Begin Included Message -----
>
> > I believe that the JAPAN memory maker catching on fire is BS.  Has anyone
> > seen photos of the burnt SIMMS plant?
>
> > Regards,
> >         greg
>
>
>
> There was a lot of news coverage about the fire.  I saw lots of photos...but
>  wait!  Maybe those were forged
> to make me think it was a fire (the special effects *were* pretty good)...thus
>  causing a run on the market
> and potentially causing a stock market crash...
> ----- End Included Message -----
>
> The fire was at a plant the makes resigns used in the manufature of IC's.
> The plant was a third source for Intel and other US IC manfs. It's unlikely
> that it would really affect Memory availability. That's not to say
> simm manfs might not do some gouging to take advantage of the misinformation
> about the impact of the fire
> .
>
The gouging has already started here in Sunnyvale, CA. A local superstore
raised prices of 4M SIMMs about $40.00 since the alleged fire.

g.mo


-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Mon, 26 Jul 1993 09:23:52 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bob Hambuchen <[e-mail]>
Subject:      Re: Access Distribution Kit on a 4MB system...

1. I don't believe you will ever be satisfied with an Access application
   running on 4MB of memory.  It seems to run fine on 8Mb, though.

2. I wouldn't compare speed with Excel because you are comparing apples
   and oranges.  It really depends upon what the Excel application is
   doing.  Under normal circumstances I believe you will fine Excel runs
   much faster, but you will also find Access does a better job of
   relational database work.

3. If I understand your third question, Access will display information
   in a datasheet view (similar to a spreadsheet) if told to do so.
   Personally, I view Visual Basic as an excellent add-on to Access.  Use
   Access to do the simple stuff, and VB to expand those basic needs to
   cover more complicated requirements.

Bob
=========================================================================
Date:         Mon, 26 Jul 1993 08:27:41 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         davidb <[e-mail]>
Subject:      Undocumented feature in Access
In-Reply-To:  note of 93-07-25 17:06

May I ask what is the function and what is the syntax and how do you use it?

David L. Baudais, C.E.T.     | Domain: [e-mail]
Information Systems Division | "A Live mind can see a window"
  CO-OP Student              | "onto a world of possibilities."
N.A.I.T.                     |
=========================================================================
Date:         Mon, 26 Jul 1993 08:48:41 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         davidb <[e-mail]>
Subject:      Access Compiler Help

I am new at using this software, so therefore please forgive me for my
ignorance. I would like to know if the comipler in Access will compile
a program to a .exe file?

David L. Baudais, C.E.T.     | Domain: [e-mail]
Information Systems Division | "A Live mind can see a window"
  CO-OP Student              | "onto a world of possibilities."
N.A.I.T.                     |
=========================================================================
Date:         Mon, 26 Jul 1993 12:15:29 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Access Compiler Help

> I am new at using this software, so therefore please forgive me for my
> ignorance. I would like to know if the comipler in Access will compile
> a program to a .exe file?


The use of a "compiler" in the Access environment is a bit misleading -- it's
 not a compiler per se -- it's really
more of a "tokenizer" (like many dialects of BASIC that are interpreted).

There isn't a full compiler as one might find /c Clipper et al, but there is an
 ADK -- Access Distribution Kit --
which allows you to bundle your application and distribute it royalty-free.


Hope this helps.


Phil Paxton
Development Editor
SAMS/Prentice-Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Mon, 26 Jul 1993 09:34:11 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Marty McMahon <[e-mail]>
Subject:      GRAPHS IN ACCESS

I'm relatively new to the use of ACCESS.  Is there a good book that explains
how to build and modify graphs using ACCESS?  Does it make more sense to
export to Excel and make them there?

[e-mail]
=========================================================================
Date:         Mon, 26 Jul 1993 09:33:34 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access Compiler Help
In-Reply-To:  <[e-mail]>; from "Phillip" at Jul 26,
              93 12:15 pm

> There isn't a full compiler as one might find /c Clipper et al, but there is a
n
>  ADK -- Access Distribution Kit --
> which allows you to bundle your application and distribute it royalty-free.

And even with this, your application will not be a single .EXE file. It
will consist of the run-tim Access EXE file, the database file (.MDB),
a number of DLL's, and maybe an outside database file or second MDB file
if you are attaching files for a network application.

By the way... I've found that if you have a few users accessing a single
Access database on a network drive, you get better performance if you do
_not_ follow the suggested method from Microsoft. They suggest you distribute
your application to each user, and _attach_ the tables from the network
drive. I've found that if, instead, each user just has the run-time EXE
file and DLL's, and directly accesses the network file for both the data
and the application, the performance is much better. I'm working on a
Banyan network, so it may be different in other cases.

Interestingly, this also has the advantage that if you have a DBA like me
who wants to continuously change and upgrade the application interface,
you only need to work with the single network database, instead of making
changes and having to re-install them for each user. Will all this access
on that single file on the network, I just make sure to make frequent
backups, and all is well ...

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Mon, 26 Jul 1993 09:37:57 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Marty McMahon <[e-mail]>
Subject:      RE>Access Compiler Help

>The use of a "compiler" in the Access environment is a bit misleading -- it's

> not a compiler per se -- it's really
>more of a "tokenizer" (like many dialects of BASIC that are interpreted).

>There isn't a full compiler as one might find /c Clipper et al, but there is >
an
>ADK -- Access Distribution Kit --
>which allows you to bundle your application and distribute it royalty-free.

I assume the ADK is a Microsoft product.  How much do they charge for it?

[e-mail]
=========================================================================
Date:         Mon, 26 Jul 1993 11:31:54 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: "'" in queries

>  Now, this may obvious when I say it, but apostrophe's and querries
>just don't get along.  I have a query form and a customer listed in the
>database as "Art's Repair Place."  It crashed my query in access basic
>when I tried to do a query based on "Art's."
>  Anyone know any really quick ways to get around this.  I don't want to
>have to parse the incoming string for apostrophe's but I think I will.  If
>you can think of anything easier, "I'm all ears."
>
>--
>      |G|   Terry Dexter               | |
>      |E|   Calvin College             |B|
>      |B|   Grand Rapids, Mi           |E|
>      | |   [e-mail]   |G|

    Parsing was my solution.  It is preaty simple though:

'-------------Example in Access Basic Follows -------------------------
Function FixIt (s as Variant) as Variant
'parce the s for ' and change them to ? (for pattern matching)
'make sure s is a String type when you call this thing.

    Dim news as String, i as Integer

    If IsNull(s) Then FixIt = Null: Exit Function
    'You can't do anything with nulls so watch out for them


    For i = 1 to Len(s)
       If Mid$(s, i, 1) = Chr$(34) Then          '34 is ASCII for ' I think.
           news = news & "?"
       Else
           news = news & mid$(s, i, 1)
       EndIf
    Next i

    FixIt = news
End Function
'-----------------------------------------------------------------------
=========================================================================
Date:         Mon, 26 Jul 1993 14:27:40 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Donn C Young <[e-mail]>
Subject:      Re: Dates and File Transfers
In-Reply-To:  <[e-mail]>

On Wed, 21 Jul 1993, Eugene Levine wrote:

> In transferring data from Mac Excel to Windows Excel to Access, my dates
> appear to be off by four years (correct date = 1990; Access date after
> transfer = 1994). Does anyone know why this is happening and whether there
> is a fix?

I ran across this problem several months ago, and while I saw another reply
to this problem I though a bit more info might be of help. First, check
your MS Excel User's Guide, Book 1 (for Windows), p. 172-3. It seems that MS
has 2 date systems, the 1900 and the 1904 date systems. MS Excel for Win and
Lotus 1-2-3 use the 1900 system by default and MS Excel for the Mac uses the
1904 system by default - don't ask me why. While Excel should recognize which
one you're using and switch automatically, if you change the date system,
only the active worksheet and only new dates are affected - old ones stay the
same. So do this before you start entering dates in a new worksheet. To
change from one to the other:

   1. choose Calculation from the Options menu
   2. for the 1904 date system, select the 1904 Date System check box
   3. for the 1900 date system, clear the 1904 Date System check box
   4. Ok it.

Good Luck,

Donn Young, OSU Cancer Center Biostatistics Unit
[e-mail]
=========================================================================
Date:         Mon, 26 Jul 1993 15:07:44 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tyrone Shiu <[e-mail]>
Subject:      Need Help to transform screen layout.

Hi:

I have developed an application in Access 1.0.  Now
that I have decided to continue all my development
work on VB 3.0 Professional version.  Is there a easy
way to carry over all the screen layout from Access
to VB?  Thanks!


                   +--------------------------------+
                   | Tyrone Shiu                    |
                   | Email: [e-mail]  |
                   +--------------------------------+

                << The above opinion is mine, not AT&T >>
=========================================================================
Date:         Tue, 27 Jul 1993 09:27:23 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: RecordCount

Dear Graeme,

Although compacting the database works for the time being. How can U be so
sure that the old problem will not occur again ie as U add and delete record
from the table, the recordcount will not revert back to 1/3 of the correct
recordcount.

If it has happened before, chances are that it will happen again.

I think it is ACCESS bug. Can anyone out there please tell Microsoft Access
to fix the bug ?  Does anyone know what is the internet address to Microsoft
Access Hot-Line ? I would like to tell them but don't know HOW to get to them.

Chor Ling
=========================================================================
Date:         Tue, 27 Jul 1993 14:38:04 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      Checking the existence of a record

This should be simple, but haven't been able to figure it out:

I have two tables linked together. Then I have a from (of Table 1), in
which I have a button "AddRecord" (to Table 2) (kind of "customer-product"
-application ("AdProduct")). Now I want the macro first to check if there
already is a record with that ID (I don't want duplicates). The way it
works now is that the macro takes me to the other form to write the data
and when I leave that record/form it complains that it's a duplicate etc.
So, I'd like to know it before writing all the data.
Hope you understood the problem (despite my poor English).

Any suggestions?

G'day and thanks in advance!
Pekka

*****************************************************************************
 Pekka Koskinen              :)
 CIMO, P.O. Box 343          :)  "If you kill a couple, you are a murderer;
 00531 Helsinki, FINLAND     :) if you kill a million, you are a conqueror."
 tel [phone]     :)
 fax [phone]     :)              (Cliffhanger)
=========================================================================
Date:         Tue, 27 Jul 1993 09:32:12 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      Re: RecordCount / Microsoft Support via Internet

> I think it is ACCESS bug. Can anyone out there please tell Microsoft Access
> to fix the bug ?  Does anyone know what is the internet address to Microsoft
> Access Hot-Line ? I would like to tell them but don't know HOW to get to them.
>
> Chor Ling

not everything that doesn't work according to our wishes is a bug.

also, microsoft does not officially provide support via internet (but borland
 does).  this does not stop
microsoft personnel from accessing internet, but they just don't provide
 official support.

(obviously a big hint to the ms personnel plugged in....)
=========================================================================
Date:         Tue, 27 Jul 1993 08:34:28 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Need Help to transform screen layout.
In-Reply-To:  Message of Mon,
              26 Jul 1993 15:07:44 EDT from <[e-mail] .COM>

On Mon, 26 Jul 1993 15:07:44 EDT Tyrone Shiu said:
>Hi:
>
>I have developed an application in Access 1.0.  Now
>that I have decided to continue all my development
>work on VB 3.0 Professional version.  Is there a easy
>way to carry over all the screen layout from Access
>to VB?  Thanks!
>
>
Funny, I had the same question last night.  Does use of the .MDB by VB 3.0
imply that VB can use the forms and queries in that .MDB?  I realize it
can't use the reports (since MS has included Crystal Reports in VB Pro),
but I was curious about the other things.  Seems like that shouldn't be
too difficult--or am I talking about .DLLs that aren't distributed with
VB 3.0?

I haven't got my copy of VB yet but I am curious...it won't affect my
purchase one way or the other, as I have some other applications in mind
that don't involve Access.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 27 Jul 1993 09:05:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Microsoft and the Internet

This was posted some time back, but not everyone may have a copy or
remember it (I know <I> didn't...).

To report bugs in Access:  Send mail to [e-mail]

To send in your wishes for upcoming versions:  [e-mail]

One caveat--I think I remember the ACCBUG address as ACC-BUG (with
the hyphen) but I didn't see it that way in the list archives.  So if
ACCBUG doesn't work, try ACC-BUG.  Or maybe someone has a hard copy
of Microsoft's letter that announced this handy?

BTW, as I told Phil Paxton, I agree with him that the record counting
problem is unlikely to be a bug.  Since Access does not provide an implicit
recordcounting function, you're flirting with disaster :) when you try
to write one in Access Basic.  "That's not a bug--it's a <feature>!"

What <does> interest me, however, is the fact that in Professional Basic
7.1 you can query an ISAM file via the LOF() function and get the number
of records returned to you.  Why can't we do that in Access?  Or am I
completely confused?  (Which would NOT surprise me...)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 27 Jul 1993 17:08:19 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re record count

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
I use count(*) to get a count of how many records are in a table.
eg
select count(*) from t1;

to do the same with a query/view

select count(*) from t1 where x=20;

This is a common technique used on other database systems which
wont give you the record count either. Sadly this means that you
effectively perform the query twice, which can be costly
depending on whether access to the data values is needed to solve
the query, or where indexes cant be used.
One also needs to be carefull in some systems if repeatable read is
provided, but we dont need to worry about that here I think.

By the way the reason that it is not always possible to get
a record count in other ways is because a) one should only use
SQL to do it, b) (more importantly) a relational dbms does not
always have to materialise the full output set before returning
the answer of the first few records to the user, furthermore
another user can add new records which could materialise in this
output set which would then invalidate the number of records in the
output set. By the way if you dont have repeatable read and the
answer set is not materialised then this could happen with the above
count(*) method as well.

In the past many techniques have been created to help deal with
this type of problem. Its good to see that some of the experience
of mainframe database applications writers might be useful
in the PC or Client Server worlds. The sad thing is that the problems
dont go away!
Anne
(A poor mainframe database DBA moving into PC and client/server
technology)

Thankyou
===============================================================
=========================================================================
Date:         Tue, 27 Jul 1993 13:13:52 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Need Help to transform screen layout.

>
> On Mon, 26 Jul 1993 15:07:44 EDT Tyrone Shiu said:
> >Hi:
> >
> >I have developed an application in Access 1.0.  Now
> >that I have decided to continue all my development
> >work on VB 3.0 Professional version.  Is there a easy
> >way to carry over all the screen layout from Access
> >to VB?  Thanks!
> >
> >
> Funny, I had the same question last night.  Does use of the .MDB by VB 3.0
> imply that VB can use the forms and queries in that .MDB?  I realize it
> can't use the reports (since MS has included Crystal Reports in VB Pro),
> but I was curious about the other things.  Seems like that shouldn't be
> too difficult--or am I talking about .DLLs that aren't distributed with
> VB 3.0?
>
> I haven't got my copy of VB yet but I am curious...it won't affect my
> purchase one way or the other, as I have some other applications in mind
> that don't involve Access.
>

I haven't had occassion to use forms from Access in Visual basic but the
Queries can most definately be used in VB. You can use existing queries, modify
 them  and even create new queries.


-- --------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Tue, 27 Jul 1993 15:39:27 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Controlling Field Widths

Does anyone know how to automagically control the width of a field when
printing a report?  I sometimes don't know how wide to make the fields and
therby loose a few characters of information.  I understand that the 'CanGrow'
property controls the vertical sizing, I'm looking for horizontal control.
Any recommendations?

Bill
=========================================================================
Date:         Wed, 28 Jul 1993 10:04:00 +0100
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Sent using PMDF-822 , routing is done by ECNICE
From:         Dennis Vroegop <[e-mail]>
Subject:      *.ldb files

Hi there,

Does anybody know what the *.ldb files are that Access makes?
They usually have a size of 0, but what they're meant to do, I don't
know. When I give somebody a copy of my database, should I also copy
these ldb's ?

VTY
Dennis Vroegop
INTERNET [e-mail]
=========================================================================
Date:         Wed, 28 Jul 1993 09:00:49 +0100
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         Stefan Focke <[e-mail]>
Subject:      How do you do this: Deleting a record

Hello!

I would like to know how you solve the following Problem.

- You have a form (based on a query) witch displays a record
- The form has a delete-button
- Pressing the delete-button should delete the displayed record
- After deletion the form should not show the first record in the query but
  the record that follows the deleted record


My solution follows. Do you know a shorter one?

-------------------------------------------------
What does my program do:

- The delete-button in the form calls DeleteRecord()
- 'nr' is the primary-key in my adress-table
- Using bookmark it moves in the dynaset to the record that is actually
  displayed in the form
- It moves in the dynaset to the next record and stores the primary key
  in 'nummer'
- Executing a delete-query
- Finding the record in the dynaset that contains 'nummer'
- Using bookmark to display this record in a form

I hope it is clear.

Stefan

-------------------------------------------------
Function DeleteRecord ()
Dim myForm As Form, myDyna As Dynaset Dim Q As QueryDef, DB As Database

    Set myForm = Forms![Adresse]
    Set myDyna = myForm.dynaset
    myDyna.bookmark = myForm.bookmark
    myDyna.MoveNext
    If Not myDyna.EOF Then
       Nummer = myDyna.Nr
    Else
       Nummer = -1
    End If

    Set DB = CurrentDB()
    Set Q = DB.CreateQueryDef("x")
    Q.SQL = "DELETE FROM Adresse WHERE Nr = "+Str(Forms![Adresse]![Nr])+";"
    Q.Execute
    Q.Close
    DB.DeleteQueryDef ("x")

    DoCmd Requery

    If Nummer >= 0 Then
       myDyna.FindFirst "Nr = " + Str(Nummer)
       myForm.bookmark = myDyna.bookmark
    End If
End Function

----------------------------------------------------------------------

Stefan Focke                  Tel. [phone]
GMD-ISA                       e-mail: [e-mail]
Rathausalle 10
D-W 5205 Sankt Augustin 1

    ********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date:         Wed, 28 Jul 1993 09:06:50 GMT0BST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Aiken <[e-mail]>
Subject:      visual Basic List

For those who want to join a VB list I have found one. Here is how to
get it :-

send
SUB VISBAS-L FIRST_NAME LAST_NAME

to

[e-mail]


David Aiken
(Windows / Network Development)
    Tel : (+44) [phone]
    Fax : (+44) [phone]
-----------------------------------------------------
DISCLAIMER :- My views are my own,
Newcastle University and its Library can speak for itself.
=========================================================================
Date:         Wed, 28 Jul 1993 08:01:19 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         MARK TURPIN <[e-mail]>
Subject:      Re: *.ldb files

LDB's hold lock information.  If you should get in a state where a record is
locked and nobody is in the database, this file can be delete.  Access will
create a new one if it is not present.
=========================================================================
Date:         Wed, 28 Jul 1993 08:28:34 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: visual Basic List
In-Reply-To:  Message of Wed,
              28 Jul 1993 09:06:50 GMT0BST from <David.Aiken@NEW CASTLE.AC.UK>

On Wed, 28 Jul 1993 09:06:50 GMT0BST Dave Aiken said:
>For those who want to join a VB list I have found one. Here is how to
>get it :-
>
>send
>SUB VISBAS-L FIRST_NAME LAST_NAME
>
>to
>
>[e-mail]
>

This is true.  Also, BITNETers can send to   LISTSERV@TAMVM1
                     Interneters can send to [e-mail]

Thought I should mention that....:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 28 Jul 1993 14:50:52 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      ?change a # to a label

This may have already been discussed, but I can't find the thread.  Here
is my question.  If I have a table people.sex and sex is an int such as
MALE = 0 and FEMALE=1, is there are way to generate a report where each
instance of 0,1 for column sex is replaced with MALE / FEMALE?  I have
done this with other report writers, although I don't know where to find
this functionality in ACCESS.  Thanks in advance for any help.

Regards,
        Greg
=========================================================================
Date:         Wed, 28 Jul 1993 14:08:17 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: ?change a # to a label
In-Reply-To:  Message of Wed,
              28 Jul 1993 14:50:52 EDT from <[e-mail] U>

Sure, Greg.  Use the Switch() function as your Control Source.  In this
case it would be something like

Switch(|Gender¢=1, "Male", |Gender¢=2, "Female")

This should do the trick unless my mind is wandering...I use this dodge
all the time.  Unfortunately Switch() will only switch 7 items and sometimes
I'd like to see it do more than that...but of course, the function would
be a mile long if it did.  :)

By the way, I don't get left and right square brackets on this terminal,
so in the above | is a left square bracket and ¢ is a right square bracket.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 28 Jul 1993 15:21:22 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bob Oberst <[e-mail]>
Subject:      ?change a # to a label

Greg,

I also was stumped by this type of manipulation, perhaps because of my
"PARADOX" mind set.  Take a look at chapter 7 in the Access User's Guide,
specifically the example on page 176 of an "update query".

Hope this helps.

Bob Oberst        [e-mail]

>
>This may have already been discussed, but I can't find the thread.  Here
>is my question.  If I have a table people.sex and sex is an int such as
>MALE = 0 and FEMALE=1, is there are way to generate a report where each
>instance of 0,1 for column sex is replaced with MALE / FEMALE?  I have
>done this with other report writers, although I don't know where to find
>this functionality in ACCESS.  Thanks in advance for any help.
>
>Regards,
>        Greg
=========================================================================
Date:         Thu, 29 Jul 1993 09:09:59 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: RecordCount

Yes, I agree and I intend to alert Microsoft about it.

Ta.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Thu, 29 Jul 1993 09:32:25 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Graeme Burton <[e-mail]>
Subject:      Re: ?change a # to a label

in the query that provides the data for the report, put in a column
such as:

gender:Iif(sex = 0,"Male","Female")

and you will get the text you require.

===============================================================================
Graeme Burton          |                             |
Student Systems Manager|                             | Phone: [phone]
Griffith University    | email:  [e-mail]  |
Nathan  4111           |                             |   Fax: [phone]
Australia              |                             |
===============================================================================
=========================================================================
Date:         Wed, 28 Jul 1993 21:41:11 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
In-Reply-To:  Your message of Wed, 28 Jul 1993 14:50:52 EDT

Try looking at the Switch function in the language reference, and create a
query using this function in a query field labeled "sex".  Good luck!
=========================================================================
Date:         Thu, 29 Jul 1993 09:36:40 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: RecordCount

Dear Nathan & Phil,

RecordCount Property is an in-built feature in Microsoft Access.
In Microsoft Access Language Reference Pg 390, it is stated that
RecordCount Property contains the number of records in a recordset.
Remarks : As you add and delete table records, the RecordCount value changes
to reflect the total number of nondeleted records.

Greg tried to use this in-built property. Initially it worked, after sometime
the recordcount does not reflect the ACTUAL recordcount. Recordcount monitored
1/3 of the correct recordcount.

I empathize with him as I have encountered exactly the same problem.


According to Microsoft Access, the RecordCount value should reflect the
latest changes BUT IT FAILS TO ACHIEVE THAT.

We DID NOT try to write one in Access Basis.

Chor Ling
=========================================================================
Date:         Thu, 29 Jul 1993 00:23:48 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Checking the existence of a record
In-Reply-To:  <[e-mail]> from "Pekka Koskinen" at
              Jul 27, 93 02:38:04 pm

>
> This should be simple, but haven't been able to figure it out:
>
> I have two tables linked together. Then I have a from (of Table 1), in
> which I have a button "AddRecord" (to Table 2) (kind of "customer-product"
> -application ("AdProduct")). Now I want the macro first to check if there
> already is a record with that ID (I don't want duplicates). The way it
> works now is that the macro takes me to the other form to write the data
> and when I leave that record/form it complains that it's a duplicate etc.
> So, I'd like to know it before writing all the data.
> Hope you understood the problem (despite my poor English).
>
> Any suggestions?
>
> G'day and thanks in advance!
> Pekka
>
> *****************************************************************************
>  Pekka Koskinen              :)
>  CIMO, P.O. Box 343          :)  "If you kill a couple, you are a murderer;
>  00531 Helsinki, FINLAND     :) if you kill a million, you are a conqueror."
>  tel [phone]     :)
>  fax [phone]     :)              (Cliffhanger)
>
        Hmm.. there is a number of things you could do I think. One that is
        at the top of my head right now is to try to find the record with this
        ID and check for errors. I think you need Access Basic for that:

'------------------------------------------------------------------
Function ExistRecord (mytable as Table, ID as variant)
        mytable.Index = "PrimaryKey"
        mytable.Seek "=", ID
        If mytable.NoMatch then
                ExistRecord = False
        Else
                ExistRecord = True
        EndIf

Exit Function
'------------------------------------------------------------------
PS. If you need to search in queries you could do the same thing but using
Dynaset.findFirst method. That is much slower however if you have a lot of
records.
*Note*  The mytable has to be opened with db.OpenTable before you do anything.
        If the table in question is in a remote database (i.e. attached) make
        sure you open that database with OpenDatabase("name") first -- you can
        only view attached tables as dynasets if you don't do that.
        I assume that the ID value is the PrimaryKey of the table in question.

Good Luck.
Dmitry
[e-mail]
=========================================================================
Date:         Thu, 29 Jul 1993 09:49:30 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      A little help non-access

Has anyone seen or heard of any listservers or info exchanges dealing
with trade or trade promotion?  I know there out here, just can't find
em.  Was hoping that fellow dbers may know of good resource.

Thanks in advance,
                  Greg
=========================================================================
Date:         Thu, 29 Jul 1993 11:25:47 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Greg Fairnak <[e-mail]>
Organization: The American University
Subject:      THANKS FOR DA HELP

Thanks for the help with the # to a string problem....  Looking forward
to helping you guys in the future.

                                  Regards,
                                          Greg
=========================================================================
Date:         Thu, 29 Jul 1993 06:40:34 LDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Selk <S=[e-mail]>
Subject:      Re: listservers or info exchanges

>Greg writes

>Has anyone seen or heard of any listservers or info exchanges dealing
>with trade or trade promotion?  I know there out here, just can't find
>em.  Was hoping that fellow dbers may know of good resource.

To get a list of mailing-lists, you can subscribe to the "List of Lists". Send
a request to be added to "[e-mail]". This list
notifies subscribers when new versions of the list are available, and how to
get them. It does not send a copy of of the list of mailing lists to all
subscribers, you have to request it.
There is also a mailing list called New-list, which announces new mailing
lists as they are created. This is also the mailing list to use to search for
a list dealing with a specific topic, and to determine if there is enough
interest if you would like to start a new list.
+---------------------------------------------+
|   SCOTT D. SELK, ALASKA AIR GUARD           |
|   BLDG 3126 STE 1, EIELSON AFB, AK 99702    |
|   INTERNET:[e-mail]           |
|   PHONE: [phone] FAX:[phone]    |
+---------------------------------------------+
=========================================================================
Date:         Fri, 30 Jul 1993 01:37:11 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Foo Say How <[e-mail]>
Subject:      request to sign off the ACCESS-L list
In-Reply-To:  <[e-mail]>

I must apologse for clustering your mail box.

I am trying to SIGNOFFS from ACCESS-L, and I am faced with this meesaage

On Thu, 29 Jul 1993, BITNET list server at INDYCMS wrote:

> No  entry for  your [e-mail]  address  could be  found in
 the
> ACCESS-L list at INDYCMS.  Here are a number of possible  reasons why you
 might
> still be getting mail from the list:
>
> 1. If you are a BITNET user, you might be subscribed under an "alias" host
 name
> for  which no  translation has  been registered  in the  BITNET nodes
 database
> (':internet.' tag in  BITEARN NODES). For instance,  'NEUVM1' and
 'VM.UNI-C.DK'
> are the same machine, but unless that fact has been registered it is
 impossible
> for   LISTSERV   to  know   that   'user@NEUVM1'   is   the  same   person
 as
> '[e-mail]'. If you suspect this might  be the case, resend your
 request
> via both e-mail and TELL/SEND.
>

What is TELL and SEND?

How can I find out about the alias host?

sayhow

[e-mail]
=========================================================================
Date:         Thu, 29 Jul 1993 12:50:37 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: Alpha Phi Omega, Tau Omicron Chapter
Subject:      Re: request to sign off the ACCESS-L list
In-Reply-To:  Message of Fri,
              30 Jul 1993 01:37:11 +0800 from <[e-mail] CHNET.SG>

Would the redistribution list administrators PLEASE check and see if this
account is subscribed to one of your lists?  He is NOT a subscriber to
ACCESS-L but is getting the mail somehow.

Thanks.
Nathan Brindle
List Administrator, ACCESS-L
=========================================================================
Date:         Thu, 29 Jul 1993 10:55:22 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Deleting a record from a form

Recently, an Access-Basic solution was given by somone for deleting the
current record displayed on a form. I had this same need, and wanted to just
institute a "DELETE" button which does the job. Come to find out, it can
be done with a 2-line macro - no messy AccessBASIC needed. Thought I'd
share it with the list:

DoMenuItem
  MenuBar: Form
  MenuName: Edit
  Command: SelectRecord
DoMenuItem
  MenuBar: Form
  MenuName: Edit
  Command: Delete

Now, I like the warning dialog, so I don't bother with a SetWarnings action
before and after. My macro has a 3rd action, a requery, to update a combo
box on the form so that you can no longer select the deleted record. Also,
after the macro above (which you attach to the OnPush or DoubleClick event)
is executed, the form displays the next (or maybe previous, not sure)
record in the table.

Works like a charm! Also fairly generic unless you have to requery specific
controls like I do.

And by the way, I cannot tell a lie: I didn't come up with this. Microsoft
Support helped me do this. It's fairly obvious once you look at it, though.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Thu, 29 Jul 1993 13:55:15 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      listservers or info exchanges

> To get a list of mailing-lists, you can subscribe to the "List of Lists". Send
> a request to be added to "[e-mail]". This list
> notifies subscribers when new versions of the list are available, and how to
> get them. It does not send a copy of of the list of mailing lists to all
> subscribers, you have to request it.
> There is also a mailing list called New-list, which announces new mailing
> lists as they are created. This is also the mailing list to use to search for
> a list dealing with a specific topic, and to determine if there is enough
> interest if you would like to start a new list.

One may also send the command LIST GLOBAL to any LISTSERV machine which will
 then forward the
request to the nearest backbone and you'll be sent a list of all LISTSERV lists
 (helpful since LISTSERV is
pretty much self-organizing whereas the "Internet-style" lists (aka alias
 exploders) which are designated by
the "x-request@" moniker crop up like mushrooms.  There are a number of large
 repositories which have a
lot of overlapping as well as unique information (beyond the
 interest-groups-request) --
All of this, of course, the result of updating my archives as I created the
 resource guide for our
"Navigating the Internet" book.

Phil Paxton
Development Editor, Eidetic, and seven-ball juggler
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 29 Jul 1993 16:03:49 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Terry E. Kiser" <[e-mail]>
Subject:      SIGNOFF

I am  going out  of town  for a few  days and  need to  unsubscribe from
ACCESS-L. Can someone tell me how to do this?
=========================================================================
Date:         Thu, 29 Jul 1993 16:38:42 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Phillip (Phil) Paxton" <[e-mail]>
Subject:      How To:  "SIGNOFF" & Alternatives

> I am  going out  of town  for a few  days and  need to  unsubscribe from
> ACCESS-L. Can someone tell me how to do this?


If it is a temporary action as you describe, the better thing to do is set your
 subscription option to
"NOMAIL" so you won't have to resubscribe when you return.  Also (for other
 lists), I've found it
handy to "NOMAIL" high-volume lists so I can still perform searches for
 research.

To set your subscription to NOMAIL

Send the command
        SET listname NOMAIL
To the LISTSERV machine sponsoring your subscription.

Hope this helps.

Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date:         Thu, 29 Jul 1993 14:23:31 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Norm Samuelson <[e-mail]>
Subject:      SIGNOFF

Like a few others who have sent to this list today, I really want
off of this list.  My host name changed recently and all the automated
listserv things out there cant find my name to remove it.  If any
human can help, PLEASE remove any of the following addresses from
this list:

 [e-mail]
 [e-mail]
 [e-mail]
 [e-mail]

or any address that includes u6969 and nersc.gov

or
 [e-mail]
 [e-mail]

This is beginning to feel like a nightmare.

- Norm -
=================================================================
Norman H. Samuelson                   [e-mail]
Lawrence Livermore National Lab       (or) [e-mail]
P.O.Box 808, L-431                    phone: [phone]
Livermore, CA 94550
=========================================================================
Date:         Thu, 29 Jul 1993 16:30:01 EST
Reply-To:     Nathan Brindle <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: List Administrator, ACCESS-L
Subject:      Re: SIGNOFF
In-Reply-To:  Message of Thu,
              29 Jul 1993 14:23:31 -0700 from <u6969%sas.nersc.g ov@LBL>

Pardon me, but I feel a tirade coming on.

On Thu, 29 Jul 1993 14:23:31 -0700 Norm Samuelson said:
>
>This is beginning to feel like a nightmare.

Yeah, and imagine if you're the list owner and seem to be the only one
who knows how to REVIEW the list to see, plainly, that you AREN'T
SUBSCRIBED to ACCESS-L.  I have looked twelve different ways for you
and the other three people who tried to get me to unsub them today.
None of you are in ACCESS-L LIST.  Which, if you read the message
LISTSERV sent you when you tried to unsubscribe, you would have already
known.

Now this means that SOMEWHERE along the line, you subscribed to a
redistribution list that receives ACCESS-L and posts it on to you.  I
have NO CONTROL over the redistribution lists (other than that I can
unsubscribe them and keep them from resubscribing--which I don't want to do).
I would think that when you subscribe to a list, you'd keep some sort
of record of it.  (Maybe I'm just a control freak, but that's what <I>
do.)  If you take the time to look at the headers of the messages you
claim are coming from ACCESS-L, I'll bet you'll find that they're being
redistributed to you from somewhere else (like [e-mail]--
sorry Martin!).

It is NOT my responsibility to hold the hands of ANYONE in the network
community, meaning that I expect no less of other netters than I do of
myself.  There is so much documentation available on LISTSERV (and if
you didn't ignore the message it sent you when you subscribed--IF you
subscribed to ACCESS-L--you would know where to get it.)

If you don't like this, I'm sorry.  My responsibility runs to the people
listed in ACCESS-L LIST on INDYCMS.  If you aren't in that list, someone
else is responsible for your subscription.  Period.

I apologize to subscribers for this outburst, but as I said about a
month ago in a similar situation, being a good net citizen implies
learning how to get around in it.  This is REALLY getting on my nerves.
This is an Access list and suddenly all the messages are about how to
unsubscribe.  Mail me privately if you have a problem, and PLEASE send
me a sample message (including headers!) so I can try to sort it out.

Nathan
=========================================================================
Date:         Thu, 29 Jul 1993 19:59:25 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: SIGNOFF
In-Reply-To:  Your message of Thu, 29 Jul 93 17:54:17 -0700

On Thu, 29 Jul 93 17:54:17 -0700 you said:  (and please pardon me forwarding
it to ACCESS-L as an example of what to look for)

[Stuff deleted]

>>Received: from hp4at.eunet.co.at by pierce.llnl.gov
> (4.1/LLNL-1.18/llnl.gov-05.92)
>> > id AA23250; Thu, 29 Jul 93 15:43:34 PDT
>>Received: by hp4at.eunet.co.at id AA27522
>>   (5.65c8/hp4at for ms-access-out); Thu, 29 Jul 1993 23:53:35 +0200
>>Received: from awiwuw11.wu-wien.ac.at by hp4at.eunet.co.at with SMTP id
> AA27518
>>  (5.65c8/hp4at for <[e-mail]>); Thu, 29 Jul 1993 23:53:26 +0200
                       =====================
Here's the critical data.  That means you're getting MS-ACCESS's repeat of
ACCESS-L.  You will have to unsub from MS-ACCESS to quit getting ACCESS-L.
Due to the fact that the two lists aren't true peers, we don't have two-
way traffic.  ACCESS-L is provided to MS-ACCESS as a feed for people in
Europe who don't have clear mailing paths to INDYCMS.  When this started
in March, everyone then on the two lists was warned that those who were
subscribed to both lists would get duplicate mailings from ACCESS-L.
The nuisance was considered reasonable since most MS-ACCESS subscribers
were having trouble subscribing to ACCESS-L.

>> Return-Path: <[e-mail]>
                 ================================
And this is why everyone thinks I'm in charge.  :)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] (preferred) or [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 30 Jul 1993 08:20:34 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: How To:  "SIGNOFF" & Alternatives
In-Reply-To:  Message of Thu,
              29 Jul 1993 16:38:42 EDT from <[e-mail]>

On Thu, 29 Jul 1993 16:38:42 EDT Phillip (Phil) Paxton said:
>> I am  going out  of town  for a few  days and  need to  unsubscribe from
>> ACCESS-L. Can someone tell me how to do this?
>
>
>Send the command
>        SET listname NOMAIL
>To the LISTSERV machine sponsoring your subscription.
>

....and when you get back, write the above with "mail" instead of "nomail".


HTH

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Fri, 30 Jul 1993 09:02:38 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Stultz <[e-mail]>
Subject:      Access Basic

Hello out there.  I am not much of a programmer, and I do not have much
experience to fall back on.  I am having horrible problems with Access Basic.
I have read both the introduction to Programming and pertinent parts of the
Language Reference, yet I can't seem to get a single function to work properly
for me.
        I have a macro which works fine, but I would like to convert it to
Access Basic.  So far, my conversion has never worked, and I must be too
oblivious to correct the problem.
        Here is the macro:
        SETWARNINGS                             [Warnings On: No]
        HOURGLASS                               [Hourglass On: Yes]
        ECHO                                    [Echo On: No]
        SETVALUE        Item: [Titles].Visible          [Expression: No]
        SETVALUE              [Moretitles].Enabled                   Yes
        SETVALUE              [Moretitles].Visible                   Yes
        SETVALUE              [Titles].Enabled                       No
        GOTO CONTROL                            [Control Name: [Moretitles]]
        SETVALUE              [More].Visible                         No

That's all.  Not very complex at all, yet I can't translate it.  The macro
currently works on the open form, which it is supposed to do.  It is attached
to a button which, when pushed, causes the [Titles] control to disappear and
the [Moretitles] control to appear in its place.  It also causes the button to
disappear.
        So far, this is the closest code I've come up with, yet it still does
not function:
        Function MoreButton()
        Docmd Hourglass True
        Docmd Echo False
        Docmd Setwarnings False
        Dim Curr as Form
        Dim F as String
        Set Curr=Screen.Activeform.Name
        Set F=Forms![Curr]
        F!Titles.Visible=False
        F!Titles.Enabled=False
        F!Moretitles.Visible=True
        F!Moretitles.Enabled=True
        F!More.Visible=False
        F!More.Enabled=False

Could somebody out there please give me some hint as to what's going wrong?  I
apologize for the length of this posting, but this has been driving me crazy
for the past few days.  Thanks in advance for any help!

        Dave Stultz
        [e-mail]
=========================================================================
Date:         Fri, 30 Jul 1993 09:26:33 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access Basic
In-Reply-To:  <[e-mail]>; from "Dave Stultz" at Jul
              30, 93 9:02 am

I think your:
 curr=Screen.ActiveForm.name
should instead be just:
 curr=Screen.ActiveForm

Without trying anything out, that is what looks wrong with your code to
me.
--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Fri, 30 Jul 1993 14:40:50 -0300
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         JEANNETTE <[e-mail]>
Subject:      Re: SIGNOFF

OK, I'm a little confused.

Access-l@indycms,....
is what you take care of

ms-access@eunet is what I'm in and things that are sent to access-l
get sent to ms-access  (is that right?)

so I need to unsub from ms-access.  so is is just a matter of
sending an unsub command to [e-mail]??
or is this where the unix list server comes in and it's up to
Martin to help me now

Sorry for being a pain.

Jeanette


> On Thu, 29 Jul 93 17:54:17 -0700 you said:  (and please pardon me forwarding
> it to ACCESS-L as an example of what to look for)
>
> [Stuff deleted]
>
> >>Received: from hp4at.eunet.co.at by pierce.llnl.gov
> > (4.1/LLNL-1.18/llnl.gov-05.92)
> >> > id AA23250; Thu, 29 Jul 93 15:43:34 PDT
> >>Received: by hp4at.eunet.co.at id AA27522
> >>   (5.65c8/hp4at for ms-access-out); Thu, 29 Jul 1993 23:53:35 +0200
> >>Received: from awiwuw11.wu-wien.ac.at by hp4at.eunet.co.at with SMTP id
> > AA27518
> >>  (5.65c8/hp4at for <[e-mail]>); Thu, 29 Jul 1993 23:53:26
 +0200
>                        =====================
> Here's the critical data.  That means you're getting MS-ACCESS's repeat of
> ACCESS-L.  You will have to unsub from MS-ACCESS to quit getting ACCESS-L.


*******************************************************************
Jeannette Perry      _O                   [e-mail]
18 Linden Ave       / |\/'       __o      Vaughan Library
Wolfville, NS      ' |__        _\<,_     Acadia University
Canada            __/   \      (*) (*)    Wolfville, NS ext. 1602
*******************************************************************
=========================================================================
Date:         Fri, 30 Jul 1993 16:40:35 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Access Basic
In-Reply-To:  Your message of Fri, 30 Jul 1993 09:02:38 -0400

Dear Dave:
        Sorry to hear about the trouble your having.  Try this: Add one line
at the end of your access basic code that says DoCmd Echo True
If you leave echo off, nothing will be displayed!
=========================================================================
Date:         Fri, 30 Jul 1993 16:42:19 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Access Basic
In-Reply-To:  Your message of Fri, 30 Jul 1993 09:02:38 -0400

Dave:
        I forgot to mention that the correct syntax for Set
Curr=Screen.Activeform.Name uses "FormName", not "Name"
Good Luck
---Rich Moldwin